148k views
1 vote
How does SQL allow implementation of the entity integrity and referential integrity constraints?

1 Answer

5 votes

Step-by-step explanation:

Entity Integrity

The Entity Integrity helps to ensure each row in a table to be a uniquely identifiable entity. For example, product ID column of products table is a primary key for the table.

Entity integrity ensures any two properties for the primary keys. The primary key for a row is unique. The primary key is not null, no component of the primary key my be set tonal. This property is unique and the second property ensures that primary key has a meaning has a value.

Referential integrity

The Referential integrity make sure that the relationship between tables remains or data is inserted, deleted or even modified. It specifies that the value that appears in a certain relation for a given set of some attributes, it also appears for the certain set of attributes in some other relation.

Referential triggered actions:

The Referential integrity actions are mostly triggered by physical and not by logical, or updates to unique value.

System trigger implement referential integrity actions.

User Christopher Klewes
by
4.3k points