\s
Referential integrity is a concept that ensures relationships between tables are consistent. In certain cases in relational database management system, inconsistency issues may arise when relationship is built between two tables. For example, if in a case, table 2 has a foreign key that points to the table 1. Referential integrity prevents the user from adding a record to table 2 that cannot be connected to table 1. Referential integrity rules are also applied in the case, when records from one table are deleted that is linked to the other. For example, if in table 1, records are Continue reading...