Question

MOVIE_CAST ActorName MovieName Role MOVIE Movie Name Description + Has-Cast/ Is-Cast-For Plays / Is-Played-By ACTOR ActorName THEATER TheaterName City State Address ZIP Phone Is-Shown-At / Is-Show-Time-For Is-Showing-At/ Is-Show-Time-At ? SHOW_TIME MovieName TheaterName City State DayOfWeek Date Show Time DISTANCE AREA TheaterName AreaName To-Theater-Is / City AreaState To-Theater-From State AreaName To-Area-Is / To-Area-From AreaState DistanceToCenterOfArea

          MOVIE_CAST
ActorName
MovieName
Role
MOVIE
Movie Name
Description
+
Has-Cast/
Is-Cast-For
Plays /
Is-Played-By
ACTOR
ActorName
THEATER
TheaterName
City
State
Address
ZIP
Phone
Is-Shown-At /
Is-Show-Time-For
Is-Showing-At/
Is-Show-Time-At
?
SHOW_TIME
MovieName
TheaterName
City
State
DayOfWeek
Date
Show Time
DISTANCE
AREA
TheaterName
AreaName
To-Theater-Is /
City
AreaState
To-Theater-From
State
AreaName
To-Area-Is /
To-Area-From
AreaState
DistanceToCenterOfArea

MOVIECAST
ActorName
MovieName
Role
MOVIE
Movie Name
Description
+
Has-Cast/
Is-Cast-For
Plays /
Is-Played-By
ACTOR
ActorName
THEATER
TheaterName
City
State
Address
ZIP
Phone
Is-Shown-At /
Is-Show-Time-For
Is-Showing-At/
Is-Show-Time-At
?
SHOWTIME
MovieName
TheaterName
City
State
DayOfWeek
Date
Show Time
DISTANCE
AREA
TheaterName
AreaName
To-Theater-Is /
City
AreaState
To-Theater-From
State
AreaName
To-Area-Is /
To-Area-From
AreaState
DistanceToCenterOfArea

Added by Andre B.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Rabeya Zahid

Step 1

First, we need to identify the entities in the problem statement: Show more…

Show all steps

Thanks for your feedback!

Design a database for your model in question 5.63(e) (Solution above). Your design should include a specification of tables and attributes as well as primary, candidate, and foreign keys. Also specify how you will enforce minimum cardinality. Document your minimum cardinality enforcement using referential integrity actions for required parents, if any, and the form in Figure 6-28(b) for required children, if any. MOVE CAST ActorName MovieName Role ACTOR ActorName Plays / Is-Played-By HesCast / Is-Cast-For MOVIE MovieName THEATER TheaterName City State Address ZIP Phone Description Is-Shown-At / Is-Show-Time-For Is-Showing-At / Is-Show-Time-At 7A SHOW_TIME MovieName TheaterName City State DayOfWeek Date ShowTime To-Area-Is / To-Area-From DISTANCE TheaterName City State AreaName AreaState AREA AreaName AreaState To-Theater-Is / To-Theater-From DistanceToCenterOfArea