Question: * * * Draw out the digram using this * * * Below is the layout for the EER diagram: Passenger: ( PassengerID , Name,

***Draw out the digram using this ***
Below is the layout for the EER diagram:
Passenger: (PassengerID, Name, ContactNumber, Email)
Flight: (FlightNumber, DepartureTime, ArrivalTime, DepartureLocation, ArrivalLocation)
Specializes into: DomesticFlight, InternationalFlight
Airline: (AirlineID, AirlineName, Headquarters)
Reservation: (ReservationID, ReservationDate, Status)
Airport: (AirportCode, AirportName, Location)
Ticket: (TicketID, Price, SeatNumber)
Relationships:
Makes: Passenger to Reservation
Includes: Reservation to Ticket
Operates: Airline to Flight
ScheduledAt: Flight, Airport, Time (ternary)
BelongsTo: Ticket to Flight
Using this structure, we can now draw the actual EER diagram. Here is a detailed diagram:
Passenger (PassengerID, Name [First Name, Last Name], ContactNumber, Email {multivalued})
Flight (FlightNumber, DepartureTime, ArrivalTime, DepartureLocation, ArrivalLocation)
DomesticFlight, InternationalFlight (Specialization)
Airline (AirlineID, AirlineName, Headquarters)
Reservation (ReservationID, ReservationDate, Status)
Airport (AirportCode, AirportName, Location)
Ticket (TicketID, Price, SeatNumber, FlightNumber, PassengerID)
Relationships:
Makes (1, N): Passenger to Reservation
Includes (1, N): Reservation to Ticket
Operates (1, N): Airline to Flight
ScheduledAt (Ternary,1, N, N): Flight, Airport, Time
BelongsTo (N,1): Ticket to Flight
By following these steps and using the example diagram given, we have outlined an EER diagram for an airline tickets reservation management system.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!