Question: Referential integrity rule means that Foreign key can never be null Foreign key may or may not be null Primary key can never be null

Referential integrity rule means that
Foreign key can never be null
Foreign key may or may not be null
Primary key can never be null
A foreign key which identifies primary key of some table T must either be wholly
null or match the value of the primary key of some row in T

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:

2.1 In designing a database, what is the referential integrity rule? (a) The primary key in a table should not be null. (b) The foreign key in a table should not be null. (c) Each table must have a...

Q:

MULTIPLE CHOICE QUESTIONS 1. Nulls, if used improperly, can create problems because they can represent ____. a. a default value b. a known, but missing, attribute value c. zero d. an unsortable value...

Q:

1) Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in the metadata of Assignment 1. You may need to use a combination of DROP TABLE, CREATE TABLE, and...

Q:

1) Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in the metadata of Assignment 1. You may need to use a combination of DROP TABLE, CREATE TABLE, and...

Q:

Relational Model Choose the option that correctly answer the question. ( 5 Points ) Which of the following sentences is TRUE? ( 2 Pnts ) a . The proper use of foreign keys is crucial to exercising...

Q:

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Q:

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Q:

Project 3 In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop database. We need to transition the logical...

Q:

In this project, you are expected to design and develop a hotel management system using MySQL database involving querying the database via Java JDBC. You should implement relevant entities and...

Q:

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

Q:

Like many newspapers, the Chicago Tribune is in trouble. The paper was bought by real estate mogul Sam Zell in 2007, who promptly filed for bankruptcy. That didnt surprise experts. What Zell did next...

Q:

Which of the two isomers in each of the following sets should have the greater basicity at the carbonyl oxygen? Explain. H,C CHCHC- OCH or HCC-o-CH CH CH

Q:

Compute the maturity value on each of the following notes. Fill in the missing entries for time or maturity date. ( Use a 3 6 0 - day year ) \ table [ [ Face Value,Date,Time,Due Date,Rate,Maturity...

Q:

After completing Organizational Design Simulation: Evolving Structures what insights did you gain about process management and about your personal managerial style? What led to success ( or failure )...

Q:

It wasnt worthwhile mentioning it. No one would listen to me anyway.

Q:

Are your feedback systems designed to capture primarily compliments or complaints?

Q:

Th eyll ask me for my PIN number, and I cant remember which one it is. I have dozens of account numbers.