Data Analysis for Database Design
Normalization Example
- Simplification by Inspection:
- When several analysts work on a common application, it is not unusual to create problems that won’t be taken care of by normalization.
- These problems are best solved through simplification by inspection, a process wherein a data entity in 3NF is further simplified by such efforts as addressing subtle data redundancy.