Chapter 6, Problem 24E

Explanation of Solution

Database diagram for airline database:

Explanation:

In the above database diagram, “Customer”, “Flight”, “Schedule”, “Route”, and “seat_Assignments” are the entities.

• The “Customer” entity contains “cust_ID”, “cust_Name”, “cust_Address” and “cust_Phone” attributes. Here, “cust_ID” is a primary key.
• The “Flight” entity contains “flight_ID”, “name”, “type” and “capacity” attributes. Here, “flight_ID” is a primary key.
• The “Schedule” entity contains “sch_ID”, “source_airport”, “dist_airport”, and “date” attributes...