In$-$Class Exercise : Exercise $3$

$($Taken from Exercise $5\mathrm{.}15)$

Consider the 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$)$

Draw a relational schema diagram specifying the foreign keys for this schema.

$38$

CIS$321$: Database Concepts & Design