We have established a Book Club at University. The students can donate the books they no longer need, and needy student can take the book they want from the club. An ISBN is an International Standard Book Number used to uniquely identify the book as well as the specific title, edition and format. Our book bank can have multiple copies of the same book as many students in the class can donate same course book after the semester. We also maintain a simple interger book-id to unique identify the books. A book can have multiple authors. We have designed the following relational database schema for book club. Book (book_id, title, ISBN, publisher, edition, no_of_copies) Author (book_id, author_name) Book_Recieved(book_id, Member_ID, date) Book_Issued (book_id, Member_ID, issue_date, return_date) Member (Member_ID, RollNo, name, email, department) a) Identify domain for each column.
We have established a Book Club at University. The students can donate the books they no longer need, and
needy student can take the book they want from the club. An ISBN is an International Standard Book Number
used to uniquely identify the book as well as the specific title, edition and format. Our book bank can have multiple
copies of the same book as many students in the class can donate same course book after the semester. We also
maintain a simple interger book-id to unique identify the books. A book can have multiple authors. We have
designed the following relational
Book (book_id, title, ISBN, publisher, edition, no_of_copies)
Author (book_id, author_name)
Book_Recieved(book_id, Member_ID, date)
Book_Issued (book_id, Member_ID, issue_date, return_date)
Member (Member_ID, RollNo, name, email, department)
a) Identify domain for each column.
b) Identify the primary key and candidate keys in each table.
c) Populate the relations with a few sample tuples, and give an example of an insertion in the Author relation that violates the referential integrity constraints and of another insertion that does not.
Step by step
Solved in 2 steps
