CODD'S 9th RULE

CODD'S 9th RULE - 102 Jasmine BBB Basketball Account 5000...

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

View Full Document Right Arrow Icon
CODD’S 9 CODD’S 9 th th RULE RULE Neha Chhabria Ritu Kasliwal Rohit Sagar Urvi Sariya FOR RELATIONAL DATABASE FOR RELATIONAL DATABASE PRESENTED BY :
Background image of page 1

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

View Full DocumentRight Arrow Icon
According to Dr.Codd A Database product should provide the three categories of features Structure Integrity Data Manipulation
Background image of page 2
Rule 0 : Foundation Rule Rule 1 : Information Rule Rule 2 : Guaranteed Access Rule Rule 3 : Systematic Treatment Of Null Values Rule Rule 4 : Active Online Catalog Based On Relational Model Rule 5 : The Comprehensive Data Sub-Language Rule Rule 6 : The View Updating Rule Rule 7 : High Level Insert, Update and Delete Rule 8 : Physical Data Independence Codd’s Rule
Background image of page 3

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

View Full DocumentRight Arrow Icon
RULE 9 : RULE 9 : LOGICAL DATA LOGICAL DATA INDEPENDENCE INDEPENDENCE
Background image of page 4
The ability to modify the logical schema without causing application programs to be rewritten. Changes should not affect the user’s ability to work with the data. Codd’s 9 th Rule states
Background image of page 5

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

View Full DocumentRight Arrow Icon
Example: empno ename add hobbies job sal doj 101 John AAA Football Clerk 1000 10-10-95
Background image of page 6
Background image of page 7

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

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9

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

View Full DocumentRight Arrow Icon
Background image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 102 Jasmine BBB Basketball Account 5000 5-10-93 Table name : EMPLOYEE empno ename add hobbies 101 John AAA Football 102 Jasmine BBB Basketball Table name : PERSONAL_DETAILS empno job sal doj 101 Clerk 1000 10-10-95 102 Account 5000 5-10-93 Table Name : JOB_DETAILS CREATE VIEW EMPLOYEE AS SELECT empno, ename, add, hobbies, job, sal, doj FROM PERSONAL_DETAILS, JOB_DETAILS WHERE PERSONAL_DETAILS.EMPNO = JOB_DETAILS.EMPNO; empno ename add hobbies job sal doj 101 John AAA Football Clerk 1000 10-10-95 102 Jasmine BBB Basketball Account 5000 5-10-93 SUMMARY This rule hides the implementation details from the user. This allows user to concentrate on the general structure rather than low-level implementation details. It is difficult to achieve Logical Data Independence. Reason being that the application programs are closely related with the logical structure of the database. THANK YOU...
View Full Document

Page1 / 10

CODD'S 9th RULE - 102 Jasmine BBB Basketball Account 5000...

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

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