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...
-
Under IFRS, interest paid can be reported as: a . Only a financing activity. b . A financing activity or an investing activity. c . A financing activity or an operating activity. d . Only an...
-
A spoilage-retarding ingredient is added in brewing beer. To determine the extent to which the taste of the beer is affected by the amount of this ingredient added to each batch, and how such taste...
-
Willie Lohmann travels from city to city in the conduct of his business. Every other year he buys a used . car for about $12,000. The auto dealer allows about $8000 as a trade-in allowance with the...
-
1-What is the significance of these three matrices regarding their relevance for strategic planning specific for southwest airlines. 2- Describe the key information for each and how information from...
-
Case Study: Google Inc.s Acquisition of AdMob; Questions 1,5 1. How do investors evaluate young technology companies such as Google and how do these investor evaluations in turn impact management...
-
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...
-
The mobility of an insect is an important part of its survival. Researchers have determined that the probability that a marked flea beetle, Phyllotreta cruciferae or Phyllotreta striolata, will be...
-
When a person faces a situation where playing one role becomes an obstacle for another because of the diversity in its nature, it is called: Group size Groupthink Role conflict Role expectations
-
How does the workplace influence an individuals behavior?
-
Which type of group model is for transitory groups with deadlines and the formation of the group does not follow the five-stage process? Five-stage model Punctuated equilibrium model Star model ...
-
True or false: If there is no linear correlation between systolic and diastolic blood pressure, then those two variables are not related in any way.
-
Why is it important to differentiate between an ordinary asset, a Section 1231 asset, and a capital asset?
-
Two thermometers are calibrated by measuring the freezing point of glacial acetic acid, which is 16.6C. Equal numbers of measurements are taken with each thermometer. The result from the first...
-
Thalina Mineral Works is one of the worlds leading producers of cultured pearls. The companys condensed statement of cash flows for the years 20182020 follows. Required Comment on Thalina Mineral...
-
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...
-
Imagine a monopolist producing software xyz is facing a competitive labor market. The monopolist has the following production technology; Q 10L0.5 K0.5. The level of capital is fixed at 1 (K = 1)....
-
3. Finding Participation & unemployment Rates [11] 2019 20 20 Total population 15 years and over 4.2 million Those 15 years and over not in the labour 1.4 million force population 4.2 million 1.4...
-
will be 0? Find all the Nash equilibria (both pure and mixed). In equilibrium, what is the probability that the sum of the players' payoffs
Study smarter with the SolutionInn App