Referential Integrity is a set of rules that avoids data inconsistency and quality problems.
The association between tables is referred to as referential integrity. A primary key is required for each table in a database and can appear in other tables as a result of its connection to the data in those other tables. Foreign keys are used when a primary key from one table appears in another table.
Foreign keys link tables together and create table interdependence. Tables can provide a hierarchy of dependencies so that altering or removing a row from one table changes the meaning of adjacent rows in other tables. The customer num column of the customer database, for instance, may be seen in the accompanying figure as both a primary key for that field and a foreign key in the orders and cust call tables.
Any rows that use that value as a foreign key lose their relevance when a row with a main key is deleted or updated with a different primary key. A foreign key's logical dependence on a primary key is known as referential integrity. The integrity of the row to which a foreign key refers—the row with the matching primary key—determines the integrity of the row that row refers to.
Referential Integrity is a set of rules that avoids data inconsistency and quality problems.
To know more about referential integrity, visit:
https://brainly.com/question/24177847
#SPJ4