Hands$-$on activity $$ Foreign Keys & Referential Integrity Constraints

Consider following relations for a database that keeps track of student enrollment in courses and the books adopted for each course:

STUDENT$($SSN$,$ Name, Major, Bdate$)$ COURSE$($Course#$,$ Cname, Dept$)$

ENROLL$($SSN$,$ Course#$,$ Quarter, Grade$)$ BOOK$\_$ADOPTION$($Course#$,$ Quarter, Book$\_$ISBN$)$ TEXT$($Book$\_$ISBN, Book$\_$Title, Publisher, Author$)$

Specify foreign keys and referential integrity constraints in the provided relational schema diagram.