Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 101 Hollywoody 18-Nov-53 102 Goofy 21-Jun-62 Part 3: Keys and the Index Using the model to the right, identify the following (write None if not applicable): DIR_NUM Table name: PLAY PLAY_CODE P LAY_NAME 1001 Cat On a Cold, Bare Roof 1002 Hold the Mayo, Pass the Bread 1003 I Never Promised You Coffee 1004 Silly Putty Goes To Washington 1005 See No Sound, Hear No Sight 1006 Starstruck in Biloxi 1007 Stranger In Parrot Ice 102 100 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 key: Fill in the table below that depict the contents of the conceptual INDEX table. Index Key Pointers