Discuss the purpose of enforcing referential integrity between two tables.
What will be an ideal response?
Referential integrity helps to guarantee consistency between related tables by enforcing rules in a database that are used to preserve relationships between tables when records are added, deleted, or changed. The purpose is to disallow a value in a related table that does not exist in a primary table; for example, entering an account for a customer who does not exist in the Customers table.
You might also like to view...
Which of the following statements is false?
a. IntStream methods range and rangeClosed each produce an ordered sequence of int values. b. IntStream methods range and rangeClosed take two int arguments representing the range of values. c. Method range produces a sequence of values from its first argument up to its second argument. d. Method rangeClosed produces a sequence of values including both of its arguments.
The statements int x = 1; int y; y = x++;
a. Assign y the value 2; b. Change the value of x to 2. c. Assign y the value 0; d. Assign y the value 1; e. The ++ is a postfix operator.
Some ____ are faster than others, and so scientists and corporations spend a lot of money and time trying to find the best one for a particular problem.
A. significant digits B. equations C. algorithms D. matrices
The conditions specified in a logical test are called ________
Fill in the blank(s) with the appropriate word(s).