CSC 455

Fall 2009

Lab 9

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 showing referential integrity constraints by drawing an arrow from the foreign key to the primary key it references.

Draw the E-R diagram that would result in the schema above.