Data Analysis for Database Design
Normalization Example
- Second Normal Form:
- The next step of data analysis is to place the entities into 2NF.
- It is assumed that you have already placed all entities into 1NF.
- 2NF looks for an anomaly called a partial dependency, meaning an attribute(s) whose value is determined by only part of the primary key.
- Entities that have a single attribute primary key are already in 2NF.
- Only those entities that have a concatenated key need to be checked.