Use the database composed of the two tables shown in Figure Q3.18.

What would be the conceptual view of the INDEX table that is described in question 26? Depict the contents of the conceptual INDEX table.

Figure Q3.18.

Data from Question 26:

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

Transcribed Image Text:

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 DIR_NUM 102 101 1002 Hold the Mayo, Pass the Bread 1003 I Never Promised You Coffee 102 1004 Silly Putty Goes To Washington 1005 See No Sound, Hear No Sight 100 101 1006 Starstruck in Biloxi 102 1007 Stranger In Parrot Ice 101