We have established a Book Club at FAST-NUCES. 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) Question : 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.
We have established a Book Club at FAST-NUCES. 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)
Question : 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 3 steps
