HARDEST ORDER EVER - QUESTIONS AND ANSWERS 5.4 Who is the...

This preview shows page 1 - 4 out of 34 pages.

QUESTIONS AND ANSWERS5.4 Who is the author of the entity-relationship data model?
5.5 Define entity. Give an example of an entity (other than one presented in this chapter).
5.7 Define attribute. Give an example attribute for the entity in your answer to ReviewQuestion 5.5.
5.8 Define identifier. Give an example identifier for the entity in your answer to ReviewQuestion 5.5.Identifiers are attributes that name, specify, locate (or otherwise identify) entity instances. Forexample, in the RealEstate Agency example in question 5.5. an identifier for the entity AGENT would be AgentID5.10 Define relationship. Give an example of a relationship (other than one presented in thischapter). Name your relationship.
5.15 What does cardinality mean?
5.16 Define the terms maximum cardinality and minimum cardinality.
5.17 Give examples of 1:1, 1:N, and N:M relationships (other than those presented in thischapter). Draw two E-R diagrams for each of your examples, one using the traditional diamondnotation, and one using IE Crow’s Foot notation.5.19 Give examples of M-M, M-O, O-M, and O-O relationships (other than those presented inthis chapter). Draw two E-R diagrams for each of your examples, one using the traditionaldiamond notation, and one using IE Crow’s Foot notation.In the Real Estate Agency each AGENT must use an agency car when on agency business.
In the Real Estate Agency. each CLIENT must be assigned to an AGENT, but there may beAGENTs who currently have no CLIENTs. This is an M-O (same as O-M, but seen reversed)relationship.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 34 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Winter
Professor
NoProfessor
Tags
Entity relationship model, Foreign key, real estate agency

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture