DataBase , please help , i have no time

it's with SQL

Q5: Use the database shown in following figure answer Questions a-c. Table name: DIRECT Table name: DIRECTOR DIR NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 101 Hollywoody 18-Nov-53 102 Goofy 21-Jun-62 Table name: PLAY PLAY_CODE PLAY_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 DIR_NUM 102 101 102 100 101 102 101 a. Identify the primary keys. b. Identify the foreign keys. c. Which table would be the basis for the INDEX table, and what would be the index key