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
Fundamentals Of Database Systems
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
ISBN: 9780133970777