Wednesday, February 18, 2015

Codd's Twelve Rules - Rule 1 - Information Rule


Codd's Twelve Rules / Rule 1 - Information Rule



Rule 1
Information Rule
Rule
All information in the relational database is represented in exactly one and only one way — by values in tables.
Description
Every piece of data/information that we store in a database permanently is in tables only. We will not be able to store in any other component other than tables.
Example

Emp_ID
EName
E101
Kumar
E102
Virat
E105
Sachin
E103
Gurucharan
E110
Kumar
Sample table Employee is given above. Here, the record of every employee is stored in the table only.
Some DBMS that fulfills this property:
SQL Server, Oracle, and MySQL support tables with rows and columns.

Go to Home - Codd's Twelve Rules



No comments:

Post a Comment