Use the database composed of the two tables shown in Figure Q3.18. Suppose you wanted quick lookup
Question:
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.
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 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
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 80% (10 reviews)
The PLAY table would ...View the full answer
Answered By
Evans Cherono
I am an Information Technology Graduate and willing to work on any computer science or IT work to ensure I do my best all the time.
5.00+
2+ Reviews
10+ Question Solved
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris
Question Posted:
Students also viewed these Computer science 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...
-
The fraud examiner's report should have what characteristics? a. Accuracy and clarity b. Relevant and material information c. Should not contain opinions or prejudices of fraud examiner. d. All of...
-
Western Electric Company pays its support staff weekly and its electricians on a semi-monthly basis. The following support staff payroll information is available for the week ended June 9, 2015: The...
-
Match each situation below to two applicable reasons that require an adjustment to be made. . Delta Airlines provided flights this month for cus- A. Revenue has been earned. tomers who paid cash last...
-
Using rules of thumb for a \(200 \mathrm{~m}^{2}\) floor area Denver residence, determine (a) the auxiliary heating energy required, (b) the solar projected area, (c) the concrete storage mass needed...
-
Assume that you are using attribute sampling to test the controls over revenue recognition of the Packet Corporation, a public company, and will use the results as part of the evidence on which to...
-
There are factors inside of a country that impacts HRM, as well as factors outside of a country that can impact HRM. For example, the laws of one country, in terms of labor union membership, can...
-
write two pages review for the article The 4 dimensions of digital trust, charted across 42 countries by Bhaskar Chakravorti, Ajay Bhalla, and Ravi Shankar Chaturvedi to give a personal opinion about...
-
Use the database composed of the two tables shown in Figure Q3.18. Identify the primary keys. Figure Q3.18. Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 18-Nov-53 101...
-
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...
-
Why does the media have a negative effect on teen girls dieting habits? Determine whether the survey question is biased. If the question is biased, suggest a better wording.
-
What are the regulatory frameworks governing the use of CRISPR-Cas9 in research and clinical applications, and how do they vary across different countries and regions ?
-
How can CRISPR-Cas9 be used to study gene regulation and epigenetic modifications, and what implications does this have for understanding complex biological processes ?
-
John Kimeu married his first and second wives under Kikuyu customary law in 1980 and 2006 respectively. In 2016, he met and married Joan Wairimu at the Registrar of Marriages Office in Machakos. In...
-
Why does political theory matter? Is a knowledge of political theory as relevant as the study of modern day political issues?
-
Why should we treat political theory as political philosophy? Why is political theory the same as political philosophy? What makes it different from political philosophy? What makes it trustworthy...
-
What is the depreciation deduction, using each of the following methods, for the second year for an asset that costs $35,000 and has an estimated MV of $7,000 at the end of its seven-year useful...
-
Rewrite Programming Exercise 7.5 using streams. Display the numbers in increasing order. Data from Programming Exercise 7.5 Write a program that reads in 10 numbers and displays the number of...
-
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.
-
SuperDry manufactures and sells T-shirts for all kinds of events. The company has two manufacturing operations shirt-making and printing. When the company receives an order, the shirt-making...
-
You want to lend $3,000 as a bank deposit in a private bank with an interest rate 3.5% compounded MONTHLY (i.e. 3.5% per month). You plan to withdraw principle and interest as a lump sum (in one...
-
Gold Star Rice, Limited, of Thailand exports Thai rice throughout Asia. The company grows three varieties of rice-White, Fragrant, and Loonzain. Budgeted sales by product and in total for the coming...
Study smarter with the SolutionInn App