User Account

All Pages

Foreign keys to maintain relationship

Assignment Help Business Management
Reference no: EM131311776

Consider the following many to many relationship:

An aircraft can be owned by many people.

A person can own many aircraft.

What would be the most appropriate way to handle the foreign keys to maintain this relationship?

A) Create a new table that has a foreign key reference to both aircrafts and people.

B) Create a foreign key in aircraft that references people.

C) Create a foreign key in people that references aircraft.

D) Combine the two tables into a single table that has properties of both people and aircraft.

E) This is not possible to model in MySQL and must be handled in the application logic.

Reference no: EM131311776

Questions Cloud

Review the scenarios and the audit checklist in the media : To prepare for this Discussion, review the scenarios and the audit checklist in the media for this Week. Be sure to take the interactive quiz in the media and make notes of the feedback you received.
What do you understand by the term the term nairu : What do you understand by the term the term NAIRU? Using an appropriate diagram, show how attempts by government to reduce unemployment below this rate by expanding aggregate demand may only lead to higher inflation, especially in the longer term.
What were the main points of the writing : What were the main points of the writing?What were the differences and similarities between what you read and what was written about the individual in the textbook?Based on your own views of psychology, how does the author's viewpoint fit into your c..
Develop organization-wide plans that focus on security : Develop organization-wide plans that focus on an integrated systems architecture, security, data architecture, and configuration management.
Foreign keys to maintain relationship : A) Create a new table that has a foreign key reference to both aircrafts and people.
Primary keys of their respective tables : Suppose TableA has 10 rows and TableB has 10 rows and that TableA.id and TableB.id are primary keys of their respective tables. Do not assume any additional constraints.
Compare and contrast cost-push and demand-pull inflation : It is sometimes said that while cost-push factors can lead to higher prices and there-fore an initial round of inflation, inflation can only be sustained by demand-pull factors. Explain this point of view.
What four steps should an organization follow : What is the relationship between management information systems and information technology?- What four steps should an organization follow in determining which technologies to use?
What is the difference between its two methodologies : What is the concept of Six Sigma? What is the difference between its two methodologies? Discuss briefly the acronym DOWNTIME in Lean Six Sigma goal?

Reviews

Write a Review

Business Management Questions & Answers

  The rental company''s manager

The Assistant Manager meets with the Manager every day and hand delivers each reviewed complaint form to the Manager, and informs the Manager about any complaints that need additional review by the Manager. The rental company's Manager reviews the co..

  Develop your companys acquisition and planning strategy

Develop your companys acquisition and planning strategy for obtaining a contract -  Analyze the manner in which utilizing SmartPay or a similar program in electronic contracting will assist your company and the Navy. Provide a rationale for your re..

  Demand for real money balances

Assume output Y and the real interest rate r are determined exogenously, and demand for real money balances is given by (M/P )d = L (i, Y ). Suppose some new technology arrives that causes people to expect Y to rise next year (with no change in Y ..

  Discuss the ethical issues surrounding orphan drugs

Discuss the ethical issues surrounding orphan drugs. Should pharmaceutical companies be allowed to charge such high prices for these drugs?

  Describe the dataset and describe each of the variables

Describe the dataset and describe each of the variables. Each student will be given a sample from a large population and each student will analyse their own sample.

  What is plannings main purpose

Problem: What is planning and what is plannings main purpose?

  Marriott international and its aspects of culturewrite a

marriott international and its aspects of culturewrite a paper on the characteristics of the company that make it one

  Explain and identify the major forces that affected

Explain and Identify the major forces that affected the Japanese yen prior to the global financial crisis in the fourth quarter of 2008?

  What are various groups that identifies as well as the goals

Start with the Org Level. Recognise the Outputs - what does it produce and sell? What are its goals? How has it been performing? Then go the group level.

  Describe the major differences between a solicited and unsol

E-Activity- Go to Acquisition Central Website, a branch of the U.S. General Services Administration (GSA) Website, located at www.acquisition.gov, and then research how the contracting process moves from pre-solicitation to contract close out. From t..

  Question related to virtual communication

Question about Virtual communication - Are radios and television forms of mediated or non-mediated communication

  Economics and quantitative analysis session

What is the midpoint method for calculating price elasticity of demand? How else can the price elasticity of demand be calculated? What is the advantage of the midpoint formula?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd