Question: Suppose you are using the database composed of the two tables shown in Figure 1 . Table Name: Director DIR _ NUM DIR _ LNAME

Suppose you are using the database composed of the two tables shown in Figure 1. Table Name: Director DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65101 Hollywoody 18-Nov-53102 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 Figure 1 Data tables DIR_NUM 102101102100101102101 Question A: Identify the primary keys. Question B: Identify the foreign keys. Question C: Create the entity relationship model.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!