In

$-$

Class Exercise

$($

Taken from Exercise

$5$

$.$

$1$

$6$

$)$

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 like this example