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.