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 N: Passenger to Reservation
Includes N: Reservation to Ticket
Operates N: Airline to Flight
ScheduledAt Ternary N N: Flight, Airport, Time
BelongsTo N: 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
