Question: Mithali, a financial analyst, is preparing data to engage in a data analysis project to predict revenue for the next period based on environmental considerations.

Mithali, a financial analyst, is preparing data to engage in a data analysis project to predict revenue for the next period based on environmental considerations. She is currently reviewing the tables to validate inter-table rules for referential integrity. Which of the following is true about referential integrity?
The primary and foreign key fields must have the same name.
All values in a foreign key should also exist as values in the corresponding primary key.
The primary and foreign key fields can have different data types.
The primary key must be single-valued, but the foreign key can be multi-valued.

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!