Advanced Database Management System - Tutorials and Notes: Codd's Twelve Rules - Rule 1 - Information Rule

Search Engine

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

Thursday, 19 February 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

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