Question: Create an ER model to represent the data use by the library. The library provides books to borrowers. Each book is described by title, edition

Create an ER model to represent the data use by the library.
The library provides books to borrowers. Each book is described by title, edition and year of publication and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan and the allowable loan period for a given copy. A borrower may loan one or many books and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.

Step by Step Solution

★★★★★

3.43 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The answer to this exercise is shown as Figure 1... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

672-CS-DB (1330).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

1. To what events must the multiple listing service system respond? Create a complete event table listing the event, trigger, source, use case, response, and destination for each event. 2. Draw an...

You are required to create a conceptual data model of the data requirements for a company that specializes in IT training. The Company has 30 instructors and can handle up to 100 trainees per...

Read the following case study, which describes the data requirements for a DVD rental company. The DVD rental company has several branches throughout the USA. The data held on each branch is the...

Please use a drawing tool to draw ERD. No hand drawing assignment will be accepted. Please use UML notations to draw the diagrams. Identify all components - Entities, Relationships (e.g. type,...

Please use a drawing tool to draw ERD. No hand drawing assignment will be accepted. You can insert your diagram in this document and submit it as word.doc format. Missing/Incorrect entity :-5 per...

Could someone please solve chapter 12 problem 14???? in the book database systems 6th edition by Thomas Connolly? 12.14 Create an ER model to represent the data used by the library. The library...

a. Create ER Diagram on Microsoft visio or ant Tool used for the creation of ERD. Attach written ERD and Picture of ERD created on Software. Create unique arrangement for ERD to prevent it from copy...

Why have labor and management tended to treat each other as adversaries in the U.S. labor relations system?

If ten field lines leave a Gaussian surface when it completely surrounds the positive end of an electric dipole, what would the count be if the surface surrounded (a) Just the other end? (b) What if...

The results for March for Savery Parts follow: Actual ( based on actual sales of 1 4 , 8 2 6 units ) Master Budget ( based on budgeted sales of 1 7 , 6 5 0 units ) Sales revenues $ 2 7 2 , 8 6 5 $ 3...

On what basis does the FSOC determine whether a bank is a SIFI?

What is Haddop and what are its basic components?

What is sparse data? Give an example.

Define and describe the basic characteristics of a NoSQL database.

Kathy is 60 years of age and self-employed. During the year (2015) she reported $100,000 of revenues and $40,000 of expenses relating to her self-employment activities. If Kathy has no other...

You are an equity analyst newly examining the financials of Titan Carpet Cleaners, and are examining measures of cash flow. The tax rate for the firm is 3 5 % , and the Payout Ratio is 1 5 % . You...

Flexibility options Gadget Twin Inc. is looking at investing in a production facility that will require an initial investment of $500,000. The facility will have a three-year useful life, and it will...