Question: True | False: Referential integrity ( RI ) means that if table A contains a foreign key that matches the primary key of table B

True | False: Referential integrity (RI) means that if table A contains a foreign key that matches the primary key of table B, the value of this foreign key must match the value of the primary key for some row in table B or be null.

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 Programming Questions!

Q:

The referential integrity rule requires that _ _ _ _ . Question 1 options: every null foreign key value must reference an existing primary key value an attribute have a corresponding value in the...

Q:

This is to be written in SQL for MS Access. Questions) 1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12 I keep getting syntax errors and I cannot figure out why. 1. Create a view named PenguinBooks. It consists of...

Q:

Match the following terms and their definitions. Some terms will not be used. A model of the users' data requirements usually expressed in terms of an entity-relationship model [ Choose ] Distributed...

Q:

With regard to relational databases, a table that contains a "foreign key" datat element is actually a "primary key" in a related table in the database. Group of answer choices True False

Q:

Create the tables as per the Database design given to you in the content. If you think about a different design, that's fine too, just justify why you think that will work better. Create the primary...

Q:

multiple choice 13. Which of the following statement is correct regarding internal control ? A) A well-designed and operated internal control environment should detect collusion perpetrated by two...

Q:

You must use Oracle for this part. Please show the complete question, query used, and print the query results. Use the TAL Distributors database only. TAL Distributor: DROP TABLE REP; CREATE TABLE...

Q:

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

Q:

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

Q:

Physical database design decisions must be made carefully because of impacts on: a ) data accessibility b ) response times c ) security d ) all of them e ) none of them 2 - An attribute ( or...

Q:

A researcher used stepwise regression to create regression models to predict BirthRate (births per 1,000) using five predictors: LifeExp (life expectancy in years), InfMort (infant mortality rate)....

Q:

A certain sprinter has a top speed of 11.0 m/s. If the sprinter starts from rest and accelerates at a constant rate, he is able to reach his top speed in a distance of 12.0 m. He is then able to...

Q:

Al signed the back of her check with the words "pay to the order of Penelope." She used alnj: Multiple Choice Special endorsement. Restrictive endorsement. Blank endorsement. Oepositionet Individual...

Q:

QUESTION 3 1 POINT Annie, a pharmacist, claims that a generic anti-histamine dose is more than 18 mg, on average. Several of her coworker do not believe her, so she decides to do a hypothesis test,...