- Depends on Application
- OLTP (Transaction processing)
- Lots of small transactions
- Need to execute updates quickly
- OLAP (Analytical processing/DSS)
- Largely Read-only
- Redundant data copies facilitate Business Intellegence applications, e.g. star schema (later)
- 3NF considered ‘normalised’
- save special cases
In Focus
3.2.03. Good or bad?