Advanced Database Management System - Tutorials and Notes: Codd's Twelve Rules - Rule 2 - Guaranteed Access Rule

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Thursday, 19 February 2015

Codd's Twelve Rules - Rule 2 - Guaranteed Access Rule


Codd's Twelve Rules - Rule 2 - Guaranteed Access Rule



Rule 2
Guaranteed Access Rule
Rule
Each and every datum (atomic value) is guaranteed to be logically accessible by resorting to a combination of table name, primary key value, and column name.
Description
We must be able to access every single piece of information from the tables in some way. The combination “Table name + Primary key + Column name” must let us find the information what we need. In the case of multiple records in the result, the combination of “Table name + Column name” or the “Table name + * “ would find what we need.
Example
SELECT Emp_Salary FROM Employee WHERE ENo = ‘101’;
          where, Employee is table name, Emp_Salary is required field, and ENo is the primary key.
Some DBMS that fulfills this property
SQL in Oracle, Transact SQL in SQL Server, and SQL in MySQL supports primary keys, and are able to access the data as said above.
 

Go to Home - Codd's Twelve Rules



1 comment:

  1. Really inspirational to hear someone pursuing their dreams and becoming successful instead of following the traditional path. I have read your article about This topic. I think it's good and impressed to know your service. Thanks for share this Information.https://www.bu.ac.th

    ReplyDelete

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents