Question: Use the database composed of the two tables shown in Figure Q3.18. Suppose you wanted quick lookup capability to get a listing of all plays

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

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?

Figure Q3.18.

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

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 DIR_NUM 1001 Cat On a Cold, Bare Roof 102 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 101 102 100 101 1006 Starstruck in Biloxi 102 1007 Stranger In Parrot Ice 101

Step by Step Solution

★★★★★

3.50 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The PLAY table would ... View full answer

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 Database Concepts Questions!

Using the STUDENT and PROFESSOR tables shown in Figure Q3.8 to illustrate the difference between a natural join, an equijoin, and an outer join. Table name: STUDENT Database name: Ch03_CollegeQue STU...

Consider the two tables shown in Figure 6.37. The TerID column in the SALES_REP relation is a foreign key referring to the primary key column TerID in the TERRITORY relation. Figure 6.37 Relations...

Consider the two tables shown in Figure 6.37: Figure 6.37 Relations SALES_REP and TERRITORY a. If a DBMS enforces an UPDATE RESTRICT option on the referential integrity constraint between SALES_REP...

1. Use the contents of Figure 2.3 to work on the following problem. The text in Figure 2.3 is reproduced below for your convenience: FIGURE 2.3 Linking Relational Tables Write the business rule(s)...

Please show all steps in Access and explanations. FIGURE Q3.18 The Ch03_Theater database tables Database name: Ch03_Theater Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 101...

1. 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? Create...

Due do questions 24-27 Database name: Ch03_Theater Table name: DIRECTOR Table name: PLAY 22. Identify the primary keys. 23. Identify the foreign keys. 24. Create the ERM. 25. Create the relational...

1 5 . 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? ( Use...

Lab 1.2 Instructions (1 point for each question) Suppose you have two tables: Table Product: PROD_ID PROD_NAME PROD_PRICE PROD_PROD_DATE PROD_VENDOR 1101 Table 100 1-Jan-18 2 1102 Chair 80 3-Mar-18 3...

Suppose you are using the database composed of the following tables: a. Identify the primary keys. b. Identify the foreign keys. c. Draw the relational schema to show the relationship between...

The three bays of a base line were measured by a steel tape in catenary as 30.084, 29.973 and 25.233 m, under respective pulls of 7, 7 and 5 kg, temperatures of 12, 13 and 17C and differences of...

Visits the websites of Canadian airlines. Describe how they price segment the market. What are the ways you believe they can improve their current price segmentation strategies?

In a combination of private and public cloud where some services are used in the public cloud but some stay in our local data center with direct connection between two or more environments this type...

7. Making fun of your boss / team.

Write the business rules that are reflected in the ERD shown in Figure (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember...

Create a Crows Foot ERD for each of the following descriptions. (Note: The word many merely means more than one in the database modeling environment.) a. Each of the MegaCo Corporations divisions is...

Identify each relationship type and write all of the business rules. Discuss.

Martin Development Co. is deciding whether to proceed with Project X. The cost would be $10 million in Year 0. There is a 50% chance that X would be hugely successful and would generate annual...

On January 1, 2020, a machine costing $210,000 with a four-year life and an estimated $18,000 salvage value is installed in Apple Company's factory to Required: Compute depreciation for each year and...

Matt is analyzing two mutually exclusive projects of similar size and has prepared the following data. Both projects have 5 year lives. Matt has been asked for his best recommendation given this...