Codds Rules

Codds Rules - CoddsRules Objectives...

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

View Full Document Right Arrow Icon
    Codd’s Rules
Background image of page 1

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

View Full DocumentRight Arrow Icon
    Objectives At the end of this lesson you would be  able to enunciate and explain the  following Codd’s Rules regarding Relational  Database Its acceptance in Oracle9i 
Background image of page 2
    Codd’s Rules Dr. E. F. Codd presented twelve (12)  rules that a database must obey if it is  to be considered truly relational These rules came out of Codd’ s  theoretical work on the relational model The Rules were introduced in June  1970
Background image of page 3

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

View Full DocumentRight Arrow Icon
    Codd's Rules for RDBMS 0.   The foundation rule 1. Information rule 2. Guaranteed access rule 3. Systematic nulls rule 4. Dynamic catalogue rule 5. Comprehensive data sub-language rule
Background image of page 4
    1. View updating rule 2. High-level language rule 3. Physical data independence rule 4. Logical data independence rule 5. Integrity independence rule 6. Distribution independence rule 7. Non-subversion rule
Background image of page 5

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

View Full DocumentRight Arrow Icon
    Zero Rule The rules stem from a single foundation  rule – the “zero rule”: For a system to qualify as a Relational  Database Management System, it must  use its Relational facilities to Manage the  Database
Background image of page 6
    The Twelve rules are as follows  …….
Background image of page 7

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

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 23

Codds Rules - CoddsRules Objectives...

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

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