Hello use the attached picture to answer the question! Thank you!

Questions:

1. What is the primary key in each table? If there is none, say so.

2. What is the foreign key in each table? If there is none, say so.

3. Describe two (2) major differences between the 2 database models shown at the bottom of the page.

Chapter 3: Review Questions 22-27: The database is composed of the two tables shown below: Database name: Ch03_Theater 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 Dread 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 The entity relationship model is shown below. DIRECTOR PLAY directs + + The relational diagram is shown below. DIRECTOR IDIR NUM DIR_LNAME DIR_DOB PLAY PLAY_CODE PLAY_NAME DIR_NUM 18