Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

Exercise 1

-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.