Question 1: Benefits of referential integrity constraints. State the two major
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.