This is for the database for a movie theatre's website. The company has multiple theatres.
Problem: handling dates/show times for multiple prints of the same movie.
Current set up:
-One table for movies includes all movie specific information like rating, cast, web sites, etc. One record per movie.
-One table for dates includes the start & end date for each theatre as well as the no pass period. One record per theatre per movie.
-One table for times. Includes the auditorium number, sound format, and time. One record for each time/date set since the theatres do not run the same schedule all week. For example Fri-Sun 1:00 is one record, Fri-Sun 3:00 is a second record, Mon-Tue 3:00 is a third record.
More in the additional detail.
2007-10-09
10:02:55
·
2 answers
·
asked by
Justin H
7
in
Programming & Design