CODD'S 2ND RULE

CODD'S 2ND RULE - PRESENTATION BY PRESENTATION P.KALYAN...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: PRESENTATION BY PRESENTATION P.KALYAN BABU APRAJIT .P VENKATESWARAN .N K. SRIDHAR K. CODD’S 2 CODD’S ND RULE GUARANTEED GUARANTEED ACCESS RULE ACCESS THE RULE THE RULE Each Each and every datum (atomic value) in a relational database is guaranteed to be logically accessible by resorting to a combination of table name, primary key value, and column value. value. STUDENT TABLE STUDENT PRIMARY KEY ROLLNO NAME COURSE PHONE 1 KALI MBA 100 2 VENKI MS 101 3 APPU MS 007 4 SRI MBA 911 SELECT SELECT NAME FROM STUDENT WHERE ROLLNO=1 THIS THIS WOULD RESULT IN A SINGLE VALUE – ‘KALI’ . VALUE CONCLUSIONS CONCLUSIONS Guaranteed Guaranteed access should be strictly based on names and key values. based Users Users should only have to tell the database what their requirements are. They should not have to explain how to do it. THANK YOU THANK ...
View Full Document

Ask a homework question - tutors are online