Question: Can you consider the ERD below. Which primary key becomes a foreign key? a. CAR Owner VIN OID b. MAKE Oname MODEL COLOR oemail 1.

Can you consider the ERD below. Which primary key becomes a foreign key? a. CAR Owner VIN OID b. MAKE Oname MODEL COLOR oemail

1. OID becomes a foreign key, because a primary key on the one side becomes a foreign key on the many side of the relationship

2. VIN becomes a foreign key the mandatory participants gives to the optional side of the relationship

3. Or any other

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:

Help! Here are the questions and the database they go with. Create a PL/SQL procedure that given the name of a parking lot, print out types of permit than can park at that lot. --- code to create the...

Q:

Problem 1: Please create a PL/SQL procedure that given the name of a parking lot, print out types of permit than can park at that lot. [50 points] Problem 2: Please create a PL/SQL function that...

Q:

Help! The tables and dataset for this function are below. Create a PL/SQL function that given a license plate number and state, return the name of the owner. In case the owner cannot be found...

Q:

SQL question. My assignment is to create the following mini database. I don't know how to reference the composite primary key in the Lot _Permit_Type table. Also, would you look it over and check my...

Q:

Chapter 1 Location \"Location, Location, Location!\" Chapter Objectives On completion of this chapter the reader will understand: The influence that location has on occupancy The relationship between...

Q:

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Q:

Now: Examine the annual report for the company you have selected for your Financial Statement Analysis Report, and answer the following questions for the most recent year provided in the financial...

Q:

Using the Annual Report of your selected company answer the following questions in the Discussion: What is the value of the company's inventory at year end? What was the amount of cost of goods sold...

Q:

Study Guide Strategic Business Management By A. J. Cataldo About the Author A. J. Cataldo is currently a professor of accounting at West Chester University, in West Chester, Pennsylvania. He holds a...

Q:

Read the case scenario and use the text provided to support your answer and only used the text provided Case Scenario Dion is an engineer with Tesla Motors who helps to design electric motors. It has...

Q:

Give the structure of the principal product(s) when each of the following alcohols reacts with (1) Na2Cr2O7/H2SO4, (2) PCC, (3) DMP, (4) NaOCl. (a) Octan-1-ol (b) Octan-3-ol (c) 4-hydroxydecanal (d)...

Q:

The R&D division of Hancock Chemical Corp. has just developed a chemical for sterilizing the vicious Brazilian "killer bees" which are invading Mexico and the southern states of the United States....

Q:

Which one of the following is an appropriate way to obtain property and or liability insurance on an owned snowmobile

Q:

Ch 05- Assignment - Time Value of Money 16. Application of Time Value of Money Skills Gavin Goldenarm has been playing baseball since he was five years old and has always dreamed of playing in the...

Q:

6. Explain the strengths of a dialectical approach.

Q:

2. Discuss the types of messages that are communicated nonverbally.

Q:

3. Values and Language. Although computer-driven translations have improved dramatically over earlier attempts, translation is still intensely cultural. Communication always involves many layers of...