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
|
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.
|
No comments:
Post a Comment