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.
Computer Science & Information Technology
You might also like to view...
The Windows 10 ________ app can play the music that is stored on your PC
Fill in the blank(s) with correct word
Computer Science & Information Technology
All import declarations must be placed
a. inside the class declaration’s body. b. before the class declaration. c. after the class declaration. d. all of the above will work.
Computer Science & Information Technology