How to Split Tables
The idea is to remove redundancy
For simple problems (like the homework)
- Start with “binary relationships”
- Pairs of fields that are related
- Group together wherever possible
- Add keys where necessary
For more complicated problems
- Entity relationship modeling (LBSC 670)