Benefits of referential integrity constraints State the two-01059
This subjective question is related to the book/course
vu cs615 Software Project Management.
It can also be found in
vu cs615 Mid Term Solved Past Paper No. 1.
Question 1: Benefits of referential integrity constraints. State the two major
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.
Answer:
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.
