Exercise 3.7 Consider the relations Students, Faculty, Courses, Rooms, Enrolled, Teaches,...

Exercise 3.7 Consider the relations Students, Faculty, Courses, Rooms, Enrolled, Teaches, and MeetsIn defined in Section 1.5.2.

1. List all the foreign key constraints among these relations.
2. Give an example of a (plausible) constraint involving one or more of these relations that is not a primary key or foreign key constraint.