make ERD Fast Flight Airlines is a small air carrier operating in three north-eastern states. Fast Flight is in the process of computerizing its passenger reservation system. The following data items have been identified: reservation code, flight number, flight date, origin, destination (can be composite), departure time, arrival time, passenger name, seat number, reservation agent number (can be multivalued) and reservation agent name. For example, flight number 303, which is scheduled every Tuesday and Thursday, leaves Augusta, Maine, at 9:23am and arrives in Nashua, New Hampshire at 10:17am. You can assume that the Fast Freight reservation system will detect automatically whether empty seats are available. Draw the Entity Relationship Diagram for this system.
make ERD
Fast Flight Airlines is a small air carrier operating in three north-eastern states. Fast Flight is in the process of computerizing its passenger reservation system. The following data items have been identified: reservation code, flight number, flight date, origin, destination (can be composite), departure time, arrival time, passenger name, seat number, reservation agent number (can be multivalued) and reservation agent name. For example, flight number 303, which is scheduled every Tuesday and Thursday, leaves Augusta, Maine, at 9:23am and arrives in Nashua, New Hampshire at 10:17am. You can assume that the Fast Freight reservation system will detect automatically whether empty seats are available. Draw the Entity Relationship Diagram for this system.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
