Consder the following database schema:

STUDENTSEn, Name, Major, Boate$)$

COURSE Courses, Cname, Dept$)$

ENROLL SO CourseE, Quarter, Grade$)$

BOOK ADOPTION Course Quarter, Book isbn$)$

TEXTBook son, Book title, Publisher, Author$)$

The primary key for each relation is underlined in each relation. Specify the foreign keys for this schema $($for example, the attribute $*$ or set of atributes of relation R is the foreign key for the relation $2),$ state any assumptions that you make.

Populate the STUDENT, COURSE and ENROLL tables with a few tuples of related data. What type of constraints from the following constraints $($Domain$,$ Key, Entry integrity, and Referential Integrity constraints$)$ can be violated in Relation ENROLL under the following two operations

a$)$ insert operation,

$6)$ Delate operation

of a tuple $($or a number of tuples$).$

Use the editor to formot your answer