| Normalization |
|
|
|
|
|
|
|
|
| 1. Start with a
set of relations. |
|||||||
| 2. Identify the
FD's for them based on |
|||||||
| constraints in
the real world. |
|||||||
| 3. Modify the
relations to achieve the |
|||||||
| desired normal form: |
|||||||
| - This
frequently involves splitting apart, or |
|||||||
| decomposing,
relations. |
|||||||