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...
-
On January 1, 2010, Corgan Company acquired 80 percent of the outstanding voting stock of smashing, Inc., for a total of 980,000 in cash and other consideration, at the acquisition date, smashing had...
-
Assume HPC, Inc., began December with 60 units of inventory that cost a total of $720. During December, HPC, Inc., purchased and sold goods as follows: HPC, Inc., uses perpetual inventory. Under the...
-
What do you think are the main reasons for the trend toward "managing by the numbers," as discussed in the case? Do you believe that this is happening in many organizations, or is it an isolated...
-
The real rate of interest is 2.5%. Inflation is expected to be 3.5% in the upcoming year, 3% next year, and then 2% per year after year 2. The maturity risk premium is 0.2%(t - 1), where t is the...
-
Find point estimates for the mean and standard deviation of the Months Customer data in the Credit Risk Data file. Draw five random samples of sizes 50 and 250 from the data using the Sampling tool....
-
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...
-
The give-to-get economic exchange associated with debt financing involves which two events? a.Issue Debt and Receive Cash b.Issue Debt and Disburse Cash c.Receive Cash and Disburse Cash d. None of...
-
A proct has the following ter toda Year Cash Flow (3) 600 O a. 16.02% O b. 15.28% O c. 14.58% O d. 14.79% O e. 14.22% O f. 15.66% O g. 15.46% Oh. 14.89% 450 300 Hint CF, is not given. First, you need...
-
"Conceptualizing Leadership Questionnaire" in Northouse, The Leadership Analysis Include the following: Comprehension: Share the findings of the questionnaire. Application: Of the six dimensions in...
-
The Smelting Department of Kiner Company has the following production data for November 4 Production: Beginning work in process 2.700 units that are 100% complete as to materials and 22% complete as...
-
3. What is the output after executing the following java statements? public class Assig1_3{ public static void main (String[] args) { = String strl "Welcome"; String str2="to Java programming";...
-
answer the following questions. 1. What aspects of Orbitz's service processes led to Mr. Paton's favorable service experience? 2. Generalize the lessons learned from this example to other...
-
Determine the total charge transferred over the time interval of 0 t 10 s when i( t) = 1/2 t A.
-
Use multiplication or division of power series to find the first three nonzero terms in the Maclaurin series for each function. y = e x2 cos x
-
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.
-
Discuss how data deduplication works in backup systems and its impact on storage efficiency. What are some potential drawbacks of deduplication, and how might they be mitigated ?
-
Describe the importance of application consistency in backup operations. How do modern backup systems ensure consistency, and what are the risks of a quiescence failure ?
-
X1155: Throwing an Exception The method below takes in a String parameter representing a username. It should throw an Exception if the username is less than 3 characters long. The method correctly...
Study smarter with the SolutionInn App