Referential integrity requires that a foreign key must have a matching primary key or it must be null. This constraint is specified between two tables (parent and child); it maintains the correspondence between rows in these tables. It means the reference from a row in one table to another table must be valid.
Referential integrity is important, because it keeps you from introducing errors into your database. Suppose you have an Order Parts table like the following. Part number and order number, each foreign keys in this relation, also form the composite primary key. ... Such a situation shows a loss of referential integrity.
Referential integrity requires that a foreign key must have a matching primary key or it must be null. This constraint is specified between two tables (parent and child); it maintains the correspondence between rows in these tables. It means the reference from a row in one table to another table must be valid.
Answers & Comments
Referential integrity requires that a foreign key must have a matching primary key or it must be null. This constraint is specified between two tables (parent and child); it maintains the correspondence between rows in these tables. It means the reference from a row in one table to another table must be valid.
Referential integrity is important, because it keeps you from introducing errors into your database. Suppose you have an Order Parts table like the following. Part number and order number, each foreign keys in this relation, also form the composite primary key. ... Such a situation shows a loss of referential integrity.
Explanation:
Referential integrity requires that a foreign key must have a matching primary key or it must be null. This constraint is specified between two tables (parent and child); it maintains the correspondence between rows in these tables. It means the reference from a row in one table to another table must be valid.