CODD'S10 RULE

CODD'S10 RULE - empno ename address job 101 CCC DDD Clerk...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
RULE 10 : INTEGRITY  CONSTRAINTS Sandani Basha Phani Bhaskaran Venkat PRESENTED BY:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
 Must be defined in the relational data sub-           language and stored in the catalog, not in       the application program.  Can be changed without changes in the     application program.
Background image of page 2
Two types of Integrity Constraints: 1. Entity Integrity  –     All primary key values are unique.    No part of the primary key be null.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2. Referential Integrity  –   Rule that maintains consistency among      the rows of two tables.   Each foreign key value must match a     primary key value in the other table or      else the foreign key value can be null.
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 6
Background image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: empno ename address job 101 CCC DDD Clerk 102 EEE ZZZ Manager EXAMPLE : Table Name : EMP Table Name : DEPT deptno deptname empno head 1 Production 102 CCC 2 HR EEE SUMMARY SUMMARY No component of a Primary Key is allowed No component of a Primary Key is allowed to have a NULL value. to have a NULL value. For each distinct NON-NULL Foreign Key For each distinct NON-NULL Foreign Key value in a relational database, there must value in a relational database, there must exist a matching Primary Key value from exist a matching Primary Key value from the same domain. the same domain. THANK THANK YOU YOU...
View Full Document

Page1 / 7

CODD'S10 RULE - empno ename address job 101 CCC DDD Clerk...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online