top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How many Integrity Rules are there and what are they?

0 votes
55 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
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...