Question: you are designing a database for a library management system. the system needs to store information about books, authors, and borrowers. A book has an

you are designing a database for a library management system. the system needs to store information about books, authors, and borrowers. A book has an ID, title, genre, isbn and publication year. An author has an author id, first name, last name and nationality. A borrower has a borrower id, first name, email, last name and address. Each book is written by one author and can be borrowed by multiple borrrowers. Draw an ER diagram to model this scenario. (You are able to upload a picture with the drawing of the answer).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!