Question: Is it possible to set up a relationship between two tables and have the database allow currently existing orphaned foreign keys, but not to allow

Is it possible to set up a relationship between two tables and have the database allow currently existing "orphaned" foreign keys, but not to allow new orphaned foreign keys to be entered?

A) No

B) Yes, but only when the Foreign Key allows nulls

C) Yes

D) Not In SQL Server, but it is allowed in other Databases

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!

Overview This assignment requires you to convert a UML class diagram into a relational model, physically create tables in Microsoft Access, and enter data into the tables. The main purpose of this...

Can someone please help/advice/any idea my term project! The term project for this course will be to design and construct a database that uses appropriate Transact SQL procedures and functions. The...

CIS400 Visual Basic Programming for the Windows Environment Multiple Choice Questions Each of the following questions has only one correct answer. Circle the choice that is the best answer to each...

Group Project - Part III Kim's Flower Inc. Purchasing (Expenditure) Cycle Requirements: The final part of the project requires your team to implement the logical data model in MS Access. Please read...

Lab Exercise 2: C\# .NET 6 Class Library For exercises 24, create a blogging site using ASP.NET Web API and SQL Server Database. The site must have log in, registration, and post functionality...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Vital source: Art as LA ALEKS. Bo Waldru... Vitalsource: Art as L... 5 Letter from a Birmi... Lamar University Pr MISY 3310 - Access Assignment Total Points: 100 Premiere Products - Data Management...

SHIPMENT_LINE SHIP_ID INV_ID SL_QUANTITY SL_DATE_RECEIVED Number Number Number Date/ Time 25 09/10/2006 2 25 09/10/2006 2 25 5 200 6 200 7 200 12 100 08/15/2006 13 100 08/25/2006 23 50 08/15/2006 24...

A pre-heater involves the use of condensing steam at 100C on the inside of a bank of tubes to heat air that enters at 1 atm and 25C. The air moves at 5 m/s in cross flow over the tubes. Each tube is...

An experiment was conducted to determine the effects of three methods of soil preparation on the first-year growth of lash pine seedlings. Four locations (state forest lands) were selected, and each...

How does s 994 of the Companies Act 2006 provide an alternative remedy to a winding-up order for the minority shareholders in a company? (The Chartered Institute of Management Accountants)

Hi I need help answering the questions below on endorsement for Sports marketing 1) define the term endorsement 2) name to restrictions on endorsement 3) Name 10 celebrities and the products or...

=+ 3. Give three explanations why the real wage may remain above the level that equilibrates labor supply and labor demand.

=+ 4. Suppose that Congress passes legislation making it more diffi cult for fi rms to fi re workers. (An example is a law requiring severance pay for fi red workers.) If this legislation reduces the...

=+ 3. The residents of a certain dormitory have collected the following data: People who live in the dorm can be classifi ed as either involved in a relationship or uninvolved. Among involved