Question

Fill the blanks:

a - ____________ integrity does not allow for a key to have a NULL value, whereas

b - ____________ integrity insures that no duplicate keys are allowed in the relation.

Answer 1

Answer:

Entity integrity does not allow for a key to have a NULL value, whereas Referential integrity insures that no duplicate keys are allowed in the relation.

Explanation:

There are two type of integrity rule as follows :-
1. Entity Integrity Rule.
2. Referential Integrity Rule.

Entity Integrity Rule :- This rule says that the value of the attribute of primary key cannot contain Null values.


Referential Integrity Rule :- If a foreign key value exist in a relation ,then either the foreign key value must have a match with primary key value of the parent table or the foreign key must be null.

Thank you!!! Good luck! keep learning :)