Question: TABLE NAME: DIRECTOR ---------------------------------------------- DIR_NUM PLAY_NAME DIR_DOB -------------- ----------------- ------------------ 100 BRODWAY 12-JAN-66 101 NYC 18-NOV-53 102 CALI 21-JUN062 TABLE NAME: PLAY --------------------------------- PLAY_CODE PLAY_NAME

TABLE NAME: DIRECTOR

----------------------------------------------

DIR_NUM PLAY_NAME DIR_DOB

-------------- ----------------- ------------------

100 BRODWAY 12-JAN-66

101 NYC 18-NOV-53

102 CALI 21-JUN062

TABLE NAME: PLAY

---------------------------------

PLAY_CODE PLAY_NAME DIR_NUM

------------------------ -------------------------------- -------------------------

1001 A NAME 102

1002 AMC 101

1003 ABC 102

1004 HEY 100

1005 YAYA 101

1006 MAMA MIA 102

1007 HELLO WORD 101

1) Write the associated business rules

2) Identify the PK & FKs

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!

Q:

a. Create a view that lists all plays in alphabetical order and names of the directors. Play Director Cat Goofy Hold Hollywoody ... ... b. Find all directors who were born between January 1 st , 1962...

Q:

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

Q:

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

Q:

Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 101 Hollywoody 18-Nov-53 102 Goofy 21-Jun-62 Part 3: Keys and the Index Using the model to the right, identify the following...

Q:

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

Q:

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

Q:

Suppose you are using the database composed of the two tables shown in Figure 1 . Table Name: Director DIR _ NUM DIR _ LNAME DIR _ DOB 1 0 0 Broadway 1 2 - Jan - 6 5 1 0 1 Hollywoody 1 8 - Nov - 5 3...

Q:

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

Q:

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

Q:

Now that we've learned about NumPy let's test your knowledge. We'll start off with a few simple tasks, and then you'll be asked some more complicated questions. Import NumPy as np In [1]: import...

Q:

A die is rolled three times, if p be the probability of getting a large number than the previous number, then the value of 54p is

Q:

A British consol is an example of a ( n ) Blank _ _ _ _ _ _ . Multiple choice question. growing perpetuity growing annuity perpetuity annuity

Q:

oklu regresyon modeli balamnda bir kukla deikenin katsaysn nasl yorumlayacamz anladmzdan emin olmak iin bir kukla deikenli bir rnee dnelim. Diyelim ki spor ayakkab satlarn reklam harcamalarna ve spor...

Q:

Premium refund checks will be issued; new premium rates will be prorated and applied as payroll deductions starting June 1.Prepare an appropriate request approval letter to be sent to each employee...

Q:

Carl Bott, a systems analyst in your department, has requested approval to take a three-week leave without pay immediately following his two-week paid vacation in February. Carl and his brother want...

Q:

Technology. When you took the first can from the 12-pack of ReFresh Lemon Zest soda you bought yesterday, you knew something was wrong.You couldnt see any damage, but it was obvious the can was not...