Homework answers / question archive / Toys 4 U is a company that specialises in toy hire for parties, kindergartens and play groups

Toys 4 U is a company that specialises in toy hire for parties, kindergartens and play groups

Computer Science

Share With

---

Toys 4 U is a company that specialises in toy hire for parties, kindergartens and play groups. They also offer equipment for infants and babies for hire. Toys 4 U can own several copies (TOYCOPY) of each toy (TOY). For example, a store may have 10 copies of the toy Rocking Horse. In the database, Rocking Horse would be one TOY, and each copy would be a TOYCOPY. A hire transaction (HIRE) involves one or more copies being hired to a member (MEMBERSHIP). A copy can be hired many times over its lifetime; therefore, there is an M:N relationship between HIRE and TOYCOPY. DETAILHIRE is the bridge table to resolve this relationship.  

 

TO DO:

ER Diagram with all entity names, attribute names, primary and foreign keys, relationships, cardinality and participation indicated.

Normalise all entities, to resolve any many to many relationships. ?

Entity/table names in capitals, attributes as proper nouns, primary key underlined and foreign keys in italics

All many to many relationships should be resolved, and include a discussion of normalisation including the normal form that each entity is in and why that is optimal.