Create an erd for a database using these business rules for


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

• There are many airports where Happy 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.

Create this ERD and take a screenshot.

Solution Preview :

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

Now Priced at $50 (50% Discount)

Recommended (92%)

Rated (4.4/5)