The Question : What is Referential Integrity? Explain its two(any) purposes.
Solution for the question :
Referential Integrity is used to maintain accuracy and consistency of data in a relationship. In Base, data can be linked between two or more tables with the help of primary key and foreign key constraints.
Referential integrity helps to avoid:
1. Records can be added to a related table, if there is no associated record available in the primary key table.
2. The values can be modified in a primary if any dependent records are present in the associated table(s).
3. Deleting records from a primary key table if there are any matching related records available in associated table(s)
The correct answer to the question is researched by our moderators and shared with you. You can give feedback by commenting for the answers you think are wrong.