1.Consider the relations Students, Faculty, Courses, Rooms, Enrolled, Teaches, and Meets In de?ned in Section 1.5.2.
1a. List all the foreign key constraints among these relations.
1b. Give an example of a (plausible) constraint involving one or more of these relations that is not a primary key or foreign key constraint.
2. sid name login age gpa
53831 Madayan madayan@musi 11 1.8
53832 Guldu guldu@music 12 2.0
Figure Students with age < 18 on Instance S
Consider the SQL query whose answer is shown in Figure
1. Modify this query so that only the login column is included in the answer.
2. If the clause WHERE S.gpa >= 2 is added to the original query, what is the set of tuples in the answer?