Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create ERD for the following case Library System A library keeps records of loans of books to borrowers. Each borrower is identified by a borrower

image text in transcribed

Create ERD for the following case Library System A library keeps records of loans of books to borrowers. Each borrower is identified by a borrower number, and each copy of a book by an accession number (the library may have more than one copy of any given book). The name and address of each borrower is held so that communications, such as overdue loan reminders, can be sent when necessary. The information required about books is the title, author(s), publisher, publication date, international standard book number (ISBN), purchase price and current cost, where purchase price is the price the library paid at the time of purchase, and current cost is the current replacement cost. For analysis of usage patterns data about old loans is kept for five years Create ERD for the following case Library System A library keeps records of loans of books to borrowers. Each borrower is identified by a borrower number, and each copy of a book by an accession number (the library may have more than one copy of any given book). The name and address of each borrower is held so that communications, such as overdue loan reminders, can be sent when necessary. The information required about books is the title, author(s), publisher, publication date, international standard book number (ISBN), purchase price and current cost, where purchase price is the price the library paid at the time of purchase, and current cost is the current replacement cost. For analysis of usage patterns data about old loans is kept for five years

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

Database Internals A Deep Dive Into How Distributed Data Systems Work

Authors: Alex Petrov

1st Edition

1492040347, 978-1492040347

More Books

Students also viewed these Databases questions

Question

3. What information do participants need?

Answered: 1 week ago