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 ).