Question

GoldenMovies

The GoldenMovies 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 shown.

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 relationships to think about:

Each Theater has one to many Screens

Each Screen is in exactly one Theater

Each Showtime schedules exactly one Movie

Each …

Each Screen is scheduled by zero to many Showtimes

Each …

Each Movie has one to many major Actors

Each …

Please create ERD Table Diagram with the information above

Answer 1