Data Modeling with the Entity-Relationship Model - Database Processing: Fundamentals, Design, and Implementation - page 223

Figure 5-58
Movie Time Listing

In this case, distance cannot be an attribute of THEATER. Change your answer in
A for this situation. Specify the entity identifiers and attributes. Name the relation-
ships and identify the type and cardinality of all relationships.

C.

Suppose that you want to make this data model national. Change your answer to
B so that it can be used for other metropolitan areas. Change your answer in A for
this situation. Specify the entity identifiers and attributes. Name the relationships
and identify the type and cardinality of all relationships.

D.

Modify your answer to C to include the leading cast members. Assume that the role of a
cast member is not to be modeled. Specify the identifier of new entities and their attri-
butes. Name the relationships and identify the type and cardinality of all relationships.

E.

Modify your answer to C to include the leading cast members. Assume that the role of
a cast member is specified. Specify the identifier of new entities and their attributes.
Name the relationships and identify the type and cardinality of all relationships.

5.61 Consider the three reports in Figure 5-59. The data are samples of data that would
appear in the reports like these.

a.

Make a list of as many potential entities as these reports suggest.

B.

Examine your list to determine whether any entities are synonyms. If so, consoli-
date your list.