This is a refined version of a question I asked yesterday.
The database in question is for a movie theatre's web site. The company has multiple locations.
Movies table lists all of the movies with relevant data like cast, rating, run time, etc. Each location can play each movie.
Theatre table lists each movie theatre with info like address and phone number
Dates table lists the opening and ending date for each movie at each theatre. The dates are not necessarily the same for each theatre.
Times table lists movie id, theatre id, time start date, time end date, time, auditorium number. Each individual time is a single record, for example:
theatre 1, movie 1, friday, sunday, 1:00, aud 1
theatre 1, movie 1, friday, sunday, 3:00, aud 1
theatre 2, movie 2, friday, sunday, 1:00, aud 3
When dealing with multiple prints (copies) of a movie at the same theatre I just add additional records to the show times table with a different auditorium number. More in the added detail.
2007-10-10
08:46:08
·
1 answers
·
asked by
Justin H
7
in
Programming & Design