NF1 addresses two issues:
- A row of data cannot contain repeating groups of similar data (atomicity); and
- Each row of data must have a unique identifier (or Primary Key).
Second Normal Form: No Partial Dependencies on a Concatenated Key.
For each column ask:
- Can this column exist without one or the other part of the concatenated primary key?If the answer is "yes" — even once — then the table fails Second Normal Form.
Once the initial combined table is split, as the above question of each new sub-table that has been created till all columns are in tables that can be identified by a single non-concatenated primary key.
Third Normal Form: No Dependencies on Non-Key Attributes
No comments:
Post a Comment