Consider the following database composed of two tables. PLAY PLAY_CODE PLAY_NAME DIR_NUM 1001 Cat On a Cold, Bare Roof 102 1002 Hold the Mayo, Pass the Bread 101 1003 I Never Promised You Coffee 102...


Consider the following database composed of two tables.



PLAY















































PLAY_CODE




PLAY_NAME




DIR_NUM



1001



Cat On a Cold, Bare Roof



102



1002



Hold the Mayo, Pass the Bread



101



1003



I Never Promised You Coffee



102



1004



Silly Putty Goes To Washington



100



1005



See No Sound, Hear No Sight



101



1006



Starstruck in Biloxi



103



1007



Stranger In Parrot Ice



101




DIRECTOR































DIR_NUM




DIR_FNAME




DIR_LNAME




DIR_DOB



100



Sean



Broadway



1/12/65



101



Josh



Hollywoody



11/18/53



102



Will



Goofy



6/21/62




Identify the following keys by filling in the blanks, enter N/A if you think it's not applicable.


Play entity: Primary Key:  ? ,   Foreign Key: ?


Director entity: Primary Key: ?  ,     Foreign Key: ?



Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here