Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with part 5 Q.11 Consider the following data requirements of a library database for keeping track of library members' borrowing books from
I need help with part 5
Q.11 Consider the following data requirements of a library database for keeping track of library members' borrowing books from a few library branches The data requirements of the library application are summarized as follows BOOK entity is identified by BookId, it has title, publisher name, and multiple author names PUBLISHER entity consists of Name, Address, and Phone attributes. Name is the key for the PUBLISHER. Note: Phone number is unique LIBRARY BRANCH entity has Branchld as a key and other attributes such as Library Banch Name, Branch Address, Branch Phone Number. Note: Phone number is unique BORROWER (or Library Member) entity has MemberCID as key and additionally has name, address, phone attributes Each LIBRARY BRANCH has one or more copies of the same book. In such a case, noOfCopies attribute needs to be maintained by the relationship. A book is published by only one publisher. A book can be loaned to a library member at a specific library branch When a library member checks out a book, checking out date and time and due date and time must be stored in the databaseStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started