THEATER MOVIE Business Rules [also called Functional Dependencies) shows Write the business rules that are reflected in the ER diagram to the right (Hint: you can readily identify six rules) REVIEWER REVIEW Enter Rules here: Table name: DIRECTOR Keys and the Index DIR ORINAME IOR Using the model to the right, identify the following (write None if not applicable) 100 Broadway 12-Jan-65 18-Nov-53 21-Jun-62 101 102 Goofy Table name: PLAY PLAY CODE PLAY DIR 1001 Cot On a Cold, Bere Root 002 Hold the Mayo, Pass the Bread 1003 I Never Promised You Coffee 1004 Sly Puity Goes To Washington 1005 See No Sound, Hear No Sight 1005 Storstruck in Blon 007 Strenger 101 102 100 101 Parrot Ice 101 Enter answer here: Question Primary key in the DIRECTOR table: Foreign key in the DIRECTOR table Primary key in the PLAY table Foreign key in the PLAY table: Cardinality of the relationship between DIRECTOR and PLAY Suppose you wanted a quick lookup capability to get a listing of all plays directed by a given director. Identify the table that would be the basis of the INDEX table: and what would be the index ke Fill in the table below that depict the contents of the conceptual INDEX table Index Ke Pointers