Detail answer pleae

4. Using the database shown in figure 2, answer the following questions Fig 2: Table name: DIRECTOR Database name: Ch03_Theater Table name: PLAY a. Identify the Primary Keys b. Identify the Foreign keys c. Create the ERM d. Create the relational diagram to show the relationship between Director and Play