Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Mont FunX 0 Employee All Gwhatsut d.edu/mod/forum/view.php?id=4716135 - Students - Faculty Get Help Jessica Moore In this assignment, you are to design a database that
Mont FunX 0 Employee All Gwhatsut d.edu/mod/forum/view.php?id=4716135 - Students - Faculty Get Help Jessica Moore In this assignment, you are to design a database that meets the information processing requirements for a Library Circulation Desk as described below. A library has a collection of books each of which is identified by an ISBN (International Standard Book Number) and a copy number. The title of a book, its first author, its publisher, and its year of publication need to be kept track of. The books may be borrowed by borrowers who are identified by their social security numbers (SSN). The name and address of each borrower must be kept track of. For each book that is currently loaned out, the borroweri SSN, the date charged out, and the date due need to be stored. The library staff will be using the database application to get answers to the following types of queries: a 7:58 PM 1/21/ Query 3: List ISBN and Title of books that we carry at least 5 copies of. Query 4. How many books by Jimmy Carter (as first author) are checked out? Query S. For each year, list the number of titles published in that year that the library carries. Query 6: List borrowers with overdue books and number of days overdue. What is the best ERD to satisfy the information requirements above? Paste your ERDPlus Image Diagram as your post for grading. Make sure to include a label with your name on the ERD. The due date for posting to this forum is Saturday, January 23, 2021, 11:59 PM. 15 8 arch O 99 hp
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