top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How many Integrity Rules are there and what are they?

0 votes
258 views
How many Integrity Rules are there and what are they?
posted Sep 30, 2014 by Vidhya Sagar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

There are Three Integrity Rules. They are as follows:
Entity Integrity Rule: The Entity Integrity Rule enforces that the Primary key cannot be Null
Foreign Key Integrity Rule: The FKIR denotes that the relationship between the foreign
key and the primary key has to be enforced. When there is data in Child Tables the
Master tables cannot be deleted.
Business Integrity Rules: The Third Integrity rule is about the complex business processes
which cannot be implemented by the above 2 rules.

answer Oct 1, 2014 by Arun Gowda
...