Question: a . Create an ER diagram to represent the data use by the library. The library provides books to borrowers. Each book is described by
a Create an ER diagram to represent the data use by the library.
The library provides books to borrowers. Each book is described by title, edition and year
of publication and is uniquely identified using the ISBN. Each borrower is described by
his or her name and address and is uniquely identified using a borrower number. The
library provides one or more copies of each book and each copy is uniquely identified
using a copy number, status indicating if the book is available for loan and the allowable
loan period for a given copy. A borrower may loan one or many books and the date each
book is loaned out and is returned is recorded. The loan number uniquely identifies each
book loan
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
