Film Showings The Cinema Guild Theatre Group wants the following collection of 2

Question

Film Showings
The Cinema Guild Theatre Group wants the following collection of 21 data items to be implemented in a database
to manage its member theatres in several towns. Provide the 3NF LDM that satisfies these requirements.
Your answer must be the minimum required for a valid logical model solution. No extraneous entities or
relationships. Do not add *any* data items to the 21 items shown. You must label with a name each entity and
each relationship (between entities).

What to submit:

     -- Provide a finished 3NF LDM solution in text format
        (i.e. entities like "Entity1 ((keydata1,keydata2)(K),nonkey1,nonkey2,...)" and
               relationships like "Verb: Entity1 1:M Entity2" ),
         with one Entity or Reln per line.
   
     -- Please do not submit any bubble chart or E-R diagram.

Check carefully that you have satisfied all constraints A through K.

Actor
Address_of_Theatre
Adult_Count
Adult_Price
Child_Count
Child_Price
Date
Director
Movie_Name
Movie_Rating
Movie_Review
Number_of_Screens
Screen_Number
Senior_Count
Senior_Price
Student_Count
Student_Price
Theatre_Name
Theatre_Phone_Number
Time_of_Showing
Town

The following describe key business rules, definitions, requirements and relationships between data items:
A: Theatres can show a "double bill" (2 films for 1 admission price) or a "triple bill" (3 films) or a "festival" (a
larger number of films for one price).
B: The film distributor requires each theatre to report the count of each type of ticket sold by showing. A
showing is one start of a movie on a particular day at a specific time. Movies shown together (double bill, etc.)
have one start time.
C: A given movie may be showing at more than one theatre at the same time.
D: The movie review is a short paragraph quoted from a national magazine. The movie's rating is also based on
non-local information.
E: The database needs to track all principal actors in a movie, e.g. co-stars Bette Middler and Carrie Fisher.
F: Theatres sometimes run film festivals, where they show several films starring the same actor. (Don't handle the
festival separately, just be sure that your design for individual movies handles it.)
G: Theatres have four classes of admission with separate prices: adults, students, children, and senior citizens.
H: All prices are determined by the time of day and the day of the week (i.e. the date). Therefore, weekend and
holiday prices can be different than weekday prices. Prices can be different in each theatres showing the same
film at the same time.
I: A theatre is in only one town, but a town can have more than one theatre.
J: Most of the theatres in the theatre group have become multi-screen centers, as specified by the "Number of
Screens" data item for each theatre. For each showing, the screen number must be recorded to identify the actual
room in which the screening will occur. Date and time alone do not uniquely identify a showing.
K: Assume that a movie has only one director, but that director film festivals can be held (e.g. showing five
Alfred Hitchcock or Woody Allen movies).

Explanation / Answer

Entities

MOVIE ((Movie_name)(K),Actor,Director,Movie_Rating,Moview_Review)

THEATRE ((Theatre_Name)(K), Theatre_Phone_Number, Address_of_Theatre, Town,Number_of_Screens, Child_Count, Student_Count,Senior_Count,Adult_Count)

PRICE((Date)(k),Child_Price,Student_Price,Senior_Price,Adult_Price)

SHOWING ((Screen_Number)(K),Time_Of_Showing,Date)

Relationships

Show: THEATRE M:N MOVIE

Has: MOVIE 1:M SHOWING

Has: THEATRE 1:M SHOWING

Has: THEATRE M:N PRICE

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.