Question: We would like to construct a database to keep track of library books in a public library. Construct a crows feet diagram using the following

  1. We would like to construct a database to keep track of library books in a public library. Construct a crows feet diagram using the following information:
    1. A library carries many books
    2. Each book has an author, ISBN number, page length, and current reservation status
    3. The library keeps track of authors as well. They keep track of author names, work location, and genre.
    4. As it is a library, library patron information is kept as well. This contains a borrower ID, first name, last name, address, phone number, and current status with the library.
    5. All patron book reservations are handled in a separate table that contains borrower information, the ISBN number of the book, the date the book was checked out, as well as the due date for the book.

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!