Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions