What Are The Two Integrity Rules Used In Dbms?

1.	What Are The Two Integrity Rules Used In Dbms?
Answer» The two types of integrity RULES are referential integrity rules and entity integrity rules. Referential integrity rules dictate that a DATABASE does not contain orphan FOREIGN key values. This means that A primary key value cannot be modified if the value is USED as a foreign key in a child table. Entity integrity dictates that the primary key value cannot be Null. The two types of integrity rules are referential integrity rules and entity integrity rules. Referential integrity rules dictate that a database does not contain orphan foreign key values. This means that A primary key value cannot be modified if the value is used as a foreign key in a child table. Entity integrity dictates that the primary key value cannot be Null.

Answer»

The two types of integrity RULES are referential integrity rules and entity integrity rules. Referential integrity rules dictate that a DATABASE does not contain orphan FOREIGN key values. This means that A primary key value cannot be modified if the value is USED as a foreign key in a child table. Entity integrity dictates that the primary key value cannot be Null.

The two types of integrity rules are referential integrity rules and entity integrity rules. Referential integrity rules dictate that a database does not contain orphan foreign key values. This means that A primary key value cannot be modified if the value is used as a foreign key in a child table. Entity integrity dictates that the primary key value cannot be Null.

Discussion

No Comment Found

Related InterviewSolutions

What Exactly Is A Digital Signature?
What Is Decryption?
What Is Static Identifier?
What Are Enumerations?
Write A Binary Search Program...........
What Do You Know About The Garbage Collector?
What Is Java Applet?
What Is User Defined Exception In Java?
What Is An Interrupt?
What Is Scope Of A Variable?