I need help with this scenario below:
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
An entity-relationship diagram is a diagram that is used by a business to state the relationship between various entities.... View the full answer