Scenario: Margaret Valley's new, little library. This library consists of just books and movies (DVDs) housed in the municipal building.
View the step-by-step solution to:


I need help with this scenario below:

Scenario: Margaret

Valley's new, little library. This library consists of just books and movies (DVDs) housed in the municipal building. This building is already set up for the internet and two computers have been dedicated for library use.

Use an ERD in Gane-Sarson style.

  • Include these five entities: Book, DVD, Patron, Loan, and Fine. Do not add entities to this list.
  • For each entity, develop appropriate and thorough attributes.
  • Identify primary keys and foreign keys.
  • Use crow's feet to show relations between entities. 

Other requirements and information:

  • Be thorough with the attribute lists. You will likely have seven or more per entity; please note this number is given as a general marker for detail, not a specific measurement.
  • The "Fine" entity is where late fines or lost material costs are identified. This entity might have fewer attributes than the other four entities.
  • Ensure that there is as little redundancy as possible. Disclaimer: make sure there is enough to connect foreign keys to primary keys.
  • No entity may stand alone.
  • Since the library is being built from an individual's personal holdings, assume that there is only one copy per book or DVD.

Part 2: Explanations

Whats normalization? Include 1st, 2nd, and 3rd normal forms and why this is important.

Use a source

Critical Thinking.

Top Answer

An entity-relationship diagram is a diagram that is used by a business to state the relationship between various entities.... View the full answer


There are five entities which are Book, DUD, Patron, Loan and five
The primary keys are memberhip DDs and foreign keys are then ID. which are...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question