Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 27, 2024

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

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

9th Edition

B01JXPZ7AK, 9780805360479

More Books

Students also viewed these Databases questions

Question

★★★★★

Conserv Corporation, a computer software company, is trying to determine the appropriate accounting procedure to apply to its software development costs. Management is considering capitalizing the...

Answered: 1 week ago

Question

★★★★★

3. What does Alison mean when she says no pain no gain? To what extent do you believe that in order to achieve career success there must be an element of pain?

Answered: 1 week ago

Question

★★★★★

1. A book editor explained that he was Type B on the outside and Type A on the inside. How could this be? Do you know someone who appears to be one type of personality, but is in reality the other...

Answered: 1 week ago

Question

★★★★★

In the original Gorman Construction Company problem, we found the shortest distance from the office (node 1) to the construction site located at node 6. Because some of the roads are highways and...

Answered: 1 week ago

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 new orphaned foreign keys to be entered? A) No B)...

Answered: 1 week ago

Question

★★★★★

clear one-paragraph introduction on the importance of creating a competitive cost structure

Answered: 1 week ago

Question

★★★★★

Problem 3-12 (Algo) Predetermined Overhead Rate; Disposing of Underapplied or Overapplied Overhead [LO3-4] Luzadis Company makes furniture using the latest automated technology. The company uses a...

Answered: 1 week ago

Question

★★★★★

A country produces only ice cream and cake in the quantities and prices listed below. Use 2011 as the base year. Year Price of Ice Cream Quantity of Ice Cream Price of Cake Quantity of Cake 2011...

Answered: 1 week ago

Question

★★★★★

Leading Teams - HBR By Ethan S. Bernstein Harvard Business School React to the reading, reflect and share your impressions or experience. Use the following questions to prompt reflection a). Which...

Answered: 1 week ago

Question

★★★★★

You decide you want to be an agent with the NFL, which of the following does the NFLPA (NFL Players Association) not require at a minimum? Group of answer choices Extensive NFL knowledge (history,...

Answered: 1 week ago

Question

★★★★★

Question 19. Consider the example of a gold mine, where you have the rights to the mine for the next 20 years, over which period you plan to extract 5,000 ounces of gold every year. As an experienced...

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

=+ 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

Answered: 1 week ago

Previous Question Next Question