Create the relational diagram to show the relationship betwwen DIRECTOR and PLAY

Question

Create the relational diagram to show the relationship betwwen DIRECTOR and PLAY.

Suppose you wanted quick lookup capability to get a listing of al plays directed by a given director. Which table would be the basis for the INDEX table, and what would be the index key.

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 102 1007 Stranger In Parrot Ice 101

Explanation / Answer

There exists a 1:M relationship between the DIRECTOR table and PLAY table because there is only one row in the DIRECTOR table for any given row in the PLAY table, but there may be any rows in the PLAY table for any given row in the DIRECTOR table.


Director table would be the basis for the INDEX table and DIR_NUM would be the index key.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.