1st Normal Form

For a given table, every row must have the same columns.
To remove embeded lists:
- Separate children from parents, or -
- Provide a series of columns to hold
all of any parent's children.
But the latter method has drawbacks:
- Multiple columns hold the children
- More children require disruptive database redesign
- Ugly nulls where any parent has less than the maximum

Copyright © 1996 Applied
Information Science International