| Share this post! | Vote this! |
|
The goal of normal forms is to remove redundant data from relational database tables by splitting the tables into smaller tables without losing any of the data. It is necessary that the decomposition is lossless, meaning that you can simply come back to the base table by combining the newly created tables with joins.
First Normal Form
A relational table is in First Normal Form (1NF) if:
It has a Primary Key
Each Column is Atomic
There are no repeating groups of columns
You will see from the above that the rules have nothing to do with redundancy, but they do almost follow the rules of relational tables. A table is said to be relational if it is in First Normal Form (1NF)
More...
RECOMMENDED RADING
Normalising Your Database : First Normal Form (1NF)
Normalising Your Database : Second Normal Form (2NF)
Third Normal Form (3NF) - Normalising Your Database:
First Normal Form
A relational table is in First Normal Form (1NF) if:
It has a Primary Key
Each Column is Atomic
There are no repeating groups of columns
You will see from the above that the rules have nothing to do with redundancy, but they do almost follow the rules of relational tables. A table is said to be relational if it is in First Normal Form (1NF)
More...
RECOMMENDED RADING
Normalising Your Database : First Normal Form (1NF)
Normalising Your Database : Second Normal Form (2NF)
Third Normal Form (3NF) - Normalising Your Database:
0 comments:
Post a Comment