Question: The given database composed of the two tables shown below: Table name: DIRECTOR Database name: Ch03_Theater DIR DIR DIR 100 Broadway12-Jan-65 101 102 Goofy 18-Nov-53

The given database composed of the two tables shown below: Table

The given database composed of the two tables shown below: Table name: DIRECTOR Database name: Ch03_Theater DIR DIR DIR 100 Broadway12-Jan-65 101 102 Goofy 18-Nov-53 21-Jun-62 Table name: PLAY PLAY CODE PLAY DIR NUM 001 Cat On a Cold, Bare Root 1002 Hold the Mayo, Pass the Bread 1003 Never Promised You Coffee 1004 Silly Putty Goes To Washington 1005 See No Sound, Hear No Sight 1006 Starstruck in Biloxi 1007 Stranger In Parrot Ice 102 101 102 100 101 102 101 1. Identify the primary keys. 2. Identify the foreign key 3. What is the relationship between DIRECTOR and PLAY 4. Do these two tables exhibit entity integrity? 5. Does PAINTING exhibit referential integrity? Draw the ER diagram (Using Crow's Foot notation) to show the relationship among these 2 tables. 6

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Databases Questions!

Hello use the attached picture to answer the question! Thank you! Questions: 1. What is the primary key in each table? If there is none, say so. 2. What is the foreign key in each table? If there is...

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...

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...

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...

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...

5.Use the database shown in Figure Q3.18 to answer a-c: a.Identify the primary keys. b.Identify the foreign keys. c.Create the ERD. FIGURE The Ch03 Theater database Q3.18 tables Database name: Ch03...

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...

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...

DataBase , please help , i have no time it's with SQL Q5: Use the database shown in following figure answer Questions a-c. Table name: DIRECT Table name: DIRECTOR DIR NUM DIR_LNAME DIR_DOB 100...

THEATER MOVIE Business Rules [also called Functional Dependencies) shows Write the business rules that are reflected in the ER diagram to the right (Hint: you can readily identify six rules) REVIEWER...

One of the products that McDonalds Corp. sells is the Happy MealR, which consists of a McDonalds food entree, a small order of french fries, a small drink, and a toy. In the early 1990s, McDonalds...

The College Board reported the following mean scores for the three parts of the SAT: Critical Reading 502 Mathematics 515 Writing 494 Assume that the population standard deviation on each part of the...

Consider the following independent activities: a. Payment of a cash dividend b. Amortization of intangible asset c. Gain on disposal of equipment d. Exchange of common stock for land e. Increase in...

ASAP ASAP!!! Problem 2 An aqueous solution is prepared by dissolving 100 mg/L of CaCl2 and 230 mg/L of Na, So, in water. Assuming that these salts dissociate completely, and that the dissociated ions...

How do modern Dashboards differ from earlier implementations?

Provide an example of a descending Hierarchy of Data Validation/Lookup Tables.

In a HCM Database, how does applying Relational Design and Third Normal Form rules avoid duplication of Job Title storage in each employee base record?