Answered step by step
Verified Expert Solution
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
- 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:
- A library carries many books
- Each book has an author, ISBN number, page length, and current reservation status
- The library keeps track of authors as well. They keep track of author names, work location, and genre.
- 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.
- 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
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