educational course/tutorialoutlet.com educational course/tutorialoutlet.com | Page 77

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. costars 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 & quot; Number of Screens & quot; 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).