Question

Draw an ERD

Golden Movies

The Golden Movies theater chain specializes in showing movies from the 1960s and 70s. They have a number of Theaters in the state. Each theater has from one to nine screens (that is to say, auditoriums).

A movie is scheduled by creating a show time. The show time specifies the date, time, and screen at which that movie will be showing. For each Movie, there is a title and a date of first release.

Patrons like to be able to locate movies featuring their favorite stars, so the major actors in each movie can be searched.

Here are some things to think about:

Each theater has one to many screens

Each Screen is in exactly one theater

Each showtime schedules exactly one movie

Emphasis on each…

Each screen is scheduled by zero to many showtimes

Emphasis on each…

Each movie has one too many major actors

Emphasis on each…

Answer 1