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

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 many airplanes (airplanes have names).

· Happy Skies has many pilots (pilots have firstname, lastname).

· An airplane has one pilot.

· An airplane is assigned to an airport.

· An airplane has many flights (a flight has a flight date, and a flight name).

· Happy Skies has many passengers (firstname, lastname).

· Passengers are assigned to 1 or more flights.

Create this ERD and take a screenshot.


Comments are closed.