+2 votes
4.6k views
in Database Management Systems by
entity integrity vs referential integrity

1 Answer

+1 vote
by (user.guest)
 
Best answer

Entity integrity describes a condition in which all tuples within a table are uniquely identified by their primary key. The unique value requirement prohibits a null primary key value, because nulls are not unique.

Referential integrity describes a condition in which a foreign key value has a match in the corresponding table or in which the foreign key value is null. The null foreign key “value” makes it possible not to have a corresponding value, but the matching requirement on values that are not null makes it impossible to have an invalid value.


Please leave a comment below and share with other students in your network if you found this answer helpful. Happy learning!

Related questions

+1 vote
1 answer
0 votes
1 answer
Welcome to CPEN Talk
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...