State the two major benefits of referential integrity-01326
This subjective question is related to the book/course
vu eng201 Business and Technical English Writing.
It can also be found in
vu eng201 Mid Term Solved Past Paper No. 6.
Often, in relational database, we wish to ensure that a value that appears in one relation for a given set of attributes also appears for a certain set of attributes in another relation. This condition is called Referential integrity (RI). It is the concept of relationships between tables, based on the definition of a primary key and a foreign key.
The following summarize the benefits of referential integrity:
Ensure data integrity and consistency base on primary key and foreign key
Increases development productivity, because it is not necessary to code SQL statements to enforce referential constraints, the Teradata RDBMS automatically enforces referential integrity.
