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