Suppose that you are using the database composed of the two tables shown in table below.
Table Name: Director
DIR_NUM DIR_LNAME DIR_DOB
100 Broadway 12-jan-65
101 Hollywood 18-nov-53
102 Goofy 21-jun-62

 

Table Name: Play
PLAY_CODE PLAY_NAME DIR_NUM
1001 cat on a cold  102
1002 hold the mayo 101
1003 i never promised u coffee 102
1004 silly putty goes to washtinton 100
1005 see no sound 101
1006 starstruck in biloxi 102

(a) Identify the primary keys.
(b) Identify the foreign keys.
(c) Draw the entity relationship model.

2Comments
Akansh Singhal @akanshsinghal
1 Oct 2017 04:24 pm

a) DIR_NUM primary key of Director

    PLAY_CODE primary key of PLAY

b) DIR_NUM is foreign key of PLAY

c) ER model

Do correct me if I am wrong.

karmjit joshi @karmjitjoshi
1 Oct 2017 06:49 pm

thanks for answer akanshsinghal