The first three levels in normalising a database are:
First Normal Form (1NF): There should be no repeating groups in a table.
Second Normal Form (2NF): No non-key fields may depend on a portion of the primary key.
Third Normal From (3FN): No fields may depend on other non-key fields. In other words, each field in a record should contain information about the entity that is defined by the primary key.
First Normal Form (1NF): There should be no repeating groups in a table.
Second Normal Form (2NF): No non-key fields may depend on a portion of the primary key.
Third Normal From (3FN): No fields may depend on other non-key fields. In other words, each field in a record should contain information about the entity that is defined by the primary key.
No comments:
Post a Comment