Question: 1 . Suppose that you are using the Database composed of the two tables shown in the following figure. Use these tables to answer part

1. Suppose that you are using the Database composed of the two tables shown in the following

figure. Use these tables to answer part A,B,C (40 points)

Theater Database Tables

1. Suppose that you are using the Database composed of the two

A. Identify the primary keys for each table. ( 15 points )

B. Identify the foreign key. ( 15 points )

C. What is the relationship between these 2 tables? (10 points)

Table name: DIRECTOR Table name: PLAY

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:

Subject :IT507: Database System Design and Management 100 points Please type your answers on this document and submit this document. 1. Suppose that you are using the Database composed of the two...

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:

*Please answer all questions* 1. How many primary keys and how many foreign keys may a table have in a relational database? 2. What factors determine whether a database can contain duplicate records...

Q:

We will use a simple database composed of the following tables: CUSTOMER, INVOICE, LINE, PRODUCT, and VENDOR. This database model is shown in Figure 6.1. The database model in Figure 6.1 reflects the...

Q:

Question 1. [12.5 pts, 5 parts] Please download the dataset "economic_dashboard" in the desired format to answer the following questions using your preferred software. Statistics Canada releases...

Q:

Question 1. [12.5 pts, 5 parts) Please download the dataset "economic dashboard" in the desired format to answer the following questions using your preferred software. Statistics Canada releases...

Q:

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Q:

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Q:

Year Quarter Location CarClass Revenue NumCars 2018 Q2 Airport Premium 303242 1933 2018 Q2 Airport Hybrid 303607 1982 2018 Q2 Airport SUV 303199 2027 2019 Q2 Airport Economy 368286 2153 2018 Q1...

Q:

b. Change the values in the code so that the output tells you the probability of getting 6 individuals that are not vancomycin-resistant. Explain what is happening in this code (so why does...

Q:

Machine C was purchased on 30 November 2021 from an American supplier. Orico Limited paid the purchase price of $100 000 on 31 January 2022. The following exchange rates are applicable: Date Spot...

Q:

How might you prepare the following compounds from butanoic acid? (a) 1-Bulanol (b) Butanal (c) 1-Bromobutane (d) Pentanenitrile (e) 1-Butene (f) N-Methylpentanamidc (g) 2-Hexanone (h) Butyl benzene...

Q:

How much power is radiated by a tungsten sphere ( emissivity l o n = 0 . 3 5 ) of radius 2 0 cm at a temperature of 2 6 C ? Express your answer to two significant figures and include the appropriate...

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

e. What difficulties did they encounter?

Q:

1. Family Tree. Interview the oldest member of your family you can contact. Then answer the following questions:

Q:

2. How do these communication technologies change intercultural communication interaction?