Entities and Attributes for the Flight Reservation System
Entities serve as the building blocks of our database, representing the fundamental objects or concepts that need to be stored and managed. Attributes define the characteristics or properties of each entity. Let’s explore each entity and attribute in detail:
Flight: Represents individual flights operated by airlines.
- FlightID (Primary Key): Unique identifier for each flight.
- FlightNumber: Unique identifier for the flight assigned by the airline.
- DepartureDateTime: Date and time of flight departure.
- ArrivalDateTime: Date and time of flight arrival.
- OriginAirportCode: Three-letter code representing the origin airport.
- DestinationAirportCode: Three-letter code representing the destination airport.
- AvailableSeats: Number of available seats on the flight.
Passenger: Represents individuals booking flights.
- PassengerID (Primary Key): Unique identifier for each passenger.
- FirstName: First name of the passenger.
- LastName: Last name of the passenger.
- Email: Email address of the passenger.
- PassportNumber: Passport number of the passenger.
Airline: Represents airlines operating flights.
- AirlineID (Primary Key): Unique identifier for each airline.
- AirlineName: Name of the airline.
- ContactNumber: Contact number of the airline.
- OperatingRegion: Region(s) where the airline operates.
Airport: Represents airports serving as departure or arrival points for flights.
- AirportCode (Primary Key): Three-letter code representing the airport.
- AirportName: Name of the airport.
- Location: Location (city, country) of the airport.
- Facilities: Facilities available at the airport (e.g., parking, lounges).
Booking: Represents flight reservations made by passengers.
- BookingID (Primary Key): Unique identifier for each booking.
- FlightID (Foreign Key): Reference to the flight booked.
- PassengerID (Foreign Key): Reference to the passenger making the booking.
- PaymentStatus: Status of the payment for the booking (e.g., pending, paid).
Payment: Represents payments made for flight bookings.
- PaymentID (Primary Key): Unique identifier for each payment.
- BookingID (Foreign Key): Reference to the booking associated with the payment.
- PaymentMethod: Method used for payment (e.g., credit card, PayPal).
- Amount: Amount paid for the booking.
- TransactionDateTime: Date and time of the payment transaction.
How to Design Database for Flight Reservation System
Database design for Airline reservation system is crucial for managing flight bookings effectively. In this guide, we’ll explore the essential components and steps involved in creating such a system for flight booking, ensuring smooth operations, and user satisfaction.