Create an erd for a database using the business rules


Assignment

Create an ERD for a database using these business rules for the Happy Skies Airlines:

• TherearemanyairportswhereHappy Skies lands.
• Happy Skies has manyairplanes (airplaneshavenames).
• Happy Skies has manypilots (pilotshavefirstname, lastname).
• An airplane has one pilot.
• An airplane is assignedto an airport.
• An airplane has manyflights (a flight has a flightdate, and a flight name).
• Happy Skies has manypassengers (firstname, lastname).
• Passengersareassignedto 1 ormoreflights.

Createthis ERD andtake a screenshot.

Solution Preview :

Prepared by a verified Expert
Management Information Sys: Create an erd for a database using the business rules
Reference No:- TGS02083259

Now Priced at $45 (50% Discount)

Recommended (97%)

Rated (4.9/5)