Question

What is referential Integrity ? What does it help to avoid? Write any two.
​

Answer 1

Explanation:

$\huge{\tt{\underline{\purple{Aɳʂɯҽɾ}}}}$

↧

What is Referential Integrity?

Referential integrity is a property of data stating that all its references are valid. In the context of relational databases, it requires that if a value of one attribute of a relation references a value of another attribute, then the referenced value must exist.

↧

What does it help to avoid?

So referential integrity will prevent users from: Adding rows to a related table if there is no associated row in the primary table. Changing values in a primary table that result in orphaned records in a related table. Deleting rows from a primary table if there are matching related rows.

___________________________

${\small{\colorbox{purple}{\texttt{Hope This Help You}}}}$

$\huge{\tt{\underline{\purple{@ItzSugaryHeaven}}}}$

Answer 2

Answer:

Referential Integrity prevents your table from having incorrect or incomplete relationship e.g. If you have two tables Order and Customer where Customer is parent table with primary key customer_id and Order is child table with foreign key

Explanation:

please vote me and thanks me