3.2.03. Good or bad?

  • 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