Data Analysis for Database Design
Normalization Example
- CASE Support for Normalization:
- Most CASE tools can only normalize to first normal form.
- They accomplish this in one of two ways.
- They look for many-to-many relationships and resolve those relationships into associative entities.
- They look for attributes specifically described as having multiple values for a single entity instance.
- It is exceedingly difficult for a CASE tool to identify second and third normal form errors.
- That would require the CASE tool to have the intelligence to recognize partial and transitive dependencies.