Question: 1. Identify the primary keys. 2. Identify the foreign keys. 3. Draw the relational schema to show the relationship between DIRECTOR and PLAY. Table name:

1. Identify the primary keys. 2. Identify the foreign keys. 3.

1. Identify the primary keys.

2. Identify the foreign keys.

3. Draw the relational schema to show the relationship between DIRECTOR and PLAY.

Table name: DIRECTOR DIR NUM DIR UNAME DR DOB 00 Broadway 12 Jan 65 101 Hollywo 18.Nov.53 102 Goofy 21-Jun-62 Table name: PLAY PLAY CODE PLAY NAME 001 Cat on a cold, Bare Roof 1002 Hold the Mayo, Pass the Bread 1003 INever Promised You Coffee 1004 Sily Putty Goes To Washington 1005 See No Sound, Heer No Sight 1006 Starstruck in Blood 1007 Stranger Parrot Ice DR NUM 102 101 102 100 101 102 101

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!

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

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

Week 2 Homework (35 points) Page 1 of 3 INTRODUCTION The purpose of this assignment is to give you practice in identifying the Primary Keys (PKS) and Foreign Keys (FKs) in an existing relational...

Detail answer pleae 4. Using the database shown in figure 2, answer the following questions Fig 2: Table name: DIRECTOR Database name: Ch03_Theater Table name: PLAY a. Identify the Primary Keys b....

Skills needed: Given a non-normalized Relation (Table) and a set of functional dependencies FDs, analyze the FDs to normalize the relation up to 3NF or BCNF to avoid anomalies: 1- Identify...

SEE problem 4.25 which is attached in pdf format. I need detailed and correct answer 148 PART TWO / Databases Purchasing agent Order goods Merchandise inventory Vendor Receive goods Receiving clerk...

Need help with 1-7 Can you please draw the E-R diagram with MS Visio Database Scenario The COMPANY database keeps track of a company's employees, departments, and projects 1. The company is organized...

Give me another example with the same method of solution Goal and objectives 1 1. Database design process flowchart 2 2. Data model 3 3. Phases of database design 3 i. Requirements collection and...

Project Specification: 1. Part A: Entity Relationship Diagram 1. Your first task is to study the Case study requirements and gather as much knowledge to list all the main Entities and attributes. 2....

I only need # 3 (The ER Diagram after completing #1 and #2) solution, show the Initial Grouping, NF, Dependency Diagram, 2NF, and 3NF. When appropriate, be sure to identify all functional...

Specify two (2) catalysts that contributed to the beginnings of the modern Civil Rights Movement. Justify your response.

Which of the following news items involves a short-run decision and which involves a long-run decision? Explain.

How does a customer - centric approach impact profitability? It reduces the number of transactions It limits customer data collection It can increase revenue by improving customer satisfaction It...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

KEY QUESTION Suppose the cross elasticity of demand for products A and B is 3.6 and for products C and D is 5.4. What can you conclude about how products A and B are related? Products C and D?

KEY QUESTION Use the ideas of consumer surplus and producer surplus to explain why economists say competitive markets are efficient. Why are below- or above-equilibrium levels of output inefficient,...

KEY QUESTION Gomez runs a small pottery firm. He hires one helper at $12,000 per year, pays annual rent of $5000 for his shop, and spends $20,000 per year on materials. He has $40,000 of his own...