Use the database composed of the two tables shown in Figure Q3.18. Identify the primary keys. Figure
Question:
Identify the primary keys.
Figure Q3.18.
Transcribed Image Text:
Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 18-Nov-53 101 Hollywoody 21-Jun-62 102 Goofy Table name: PLAY PLAY_NAME 1001 Cat On a Cold, Bare Roof 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 PLAY CODE DIR_NUM 102 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: 100% (9 reviews)
DIRNUM is the DI...View the full answer
Answered By
PALASH JHANWAR
I am a Chartered Accountant with AIR 45 in CA - IPCC. I am a Merit Holder ( B.Com ). The following is my educational details.
PLEASE ACCESS MY RESUME FROM THE FOLLOWING LINK: https://drive.google.com/file/d/1hYR1uch-ff6MRC_cDB07K6VqY9kQ3SFL/view?usp=sharing
3.80+
3+ 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...
-
Google, the immensely popular Web search engine, has been touted as the closest thing the Web has to an ultimate answer machine. Although this is debatable, of course, it is far more difficult to...
-
On January 1, 2017, the ledger of Accardo Company contains the following liability accounts. Accounts Payable..................$52,000 HST Payable............................7,700 Unearned...
-
Write a program that displays the following table. Cast floatingpoint numbers into integers. pow (a, b) 2 2 3 4 81 1024 15625
-
Speculating with Currency Call Options. Randy Rudecki purchased a call option on British pounds for $.02 per unit. The strike price was $1.45, and the spot rate at the time the option was exercised...
-
Assume Max convinces Michelle to let him serve as the review partner for all audits and Michelle will serve as the engagement partner on all audits. Do you see any problems with this approach from an...
-
I would like you to build a WBS for the project you chose earlier in the class. Remember that I asked you to make sure that you had at least 30 task areas in your plan, and that translates to 30 work...
-
Effective financial statement analysis requires an understanding of a firms economic characteristics. The relations between various financial statement items provide evidence of many of these...
-
Using the tables in Figure Q3.13, create the table that results from MACHINE DIFFERENCE BOOTH. Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT MACHINE_PRICE Table...
-
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...
-
Acid-catalyzed dehydration of either 2-methyl-1-butanol or 3-methyl-1-butanol gives 2-methyl-2-butene as the major product. Write plausible mechanisms that explain these results.
-
As a manager or a coach, would you use MBO? Why or why not?
-
Develop a SWOT for the North American Society for Sport Management (NASSM).
-
Are both goals and objectives necessary for managing a health club? Why or why not?
-
What is the importance of employee growth-need strength to the job characteristics model?
-
Which of the following control activities would be most likely to as- sist in reducing the control risk related to the occurrence of inventory transactions? a. Inventory manager does not have ability...
-
Find real numbers a and b such that equations A and B describe the same curve. A: x = t + t 3 , y = 3 + t 2 ; -2 t 2 B: x = t 1/3 + t, y = 3 + t 2/3 ; a t b
-
The 2017 financial statements of the U.S. government are available at: https://www.fiscal.treasury.gov/fsreports/rpt/finrep/fr/fr_index.htm Use these to answer the following questions: a. Statement...
-
Convert the ERD from Problem 10 into the corresponding UML class diagram.
-
Create a Crows Foot ERD to include the following business rules for the ProdCo Company: a. Each sales representative writes many invoices. b. Each invoice is written by one sales representative. c....
-
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...
-
Kumara Corporation reported pretax book income of $1,530,000. Kumara also reports an increase in the taxable temporary differences of $327,500, an increase in the deductible temporary differences of...
-
Slumlord Floyd is getting a lot of complaints from tenants about how little care he takes of his rental property. Floyd ends up having several deductions disallowed under the Substandard Housing...
-
Nakashima Gallery had the following petty cash transactions in February of the current year. Nakashima uses the perpetual system to account for merchandise inventory. February 2 Wrote a $360 check to...
Study smarter with the SolutionInn App