Draw a relational schema diagram

Draw a relational schema diagram

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.

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.


Discount Code: CIPD30



Click ORDER NOW..

order custom paper