Repeat Exercise 6.5, but use the AIRLINE database schema of Figure 5.8.Exercise

Repeat Exercise 6.5, but use the AIRLINE database schema of Figure 5.8.


Exercise 6.5

Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. What are the referential integrity constraints that should hold on the schema? Write appropriate SQL DDL statements to define the database.


Figure 1.2


Figure 2.1


Figure 5.8