Database Question

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)

-----------------------------------------------------------------------

ENROLL.Ssn is a foreign key to STUDENT

ENROLL.Course# and ENROLL.Quarter are a foreign key to BOOK_ADOPTION

BOOK_ADOPTION.Course# is foreign key to COURSE

BOOK_ADOPTION.Book_isbn is foreign key to TEXT

Create an ER diagram using this information.