|< < 5 > >|

Schema Design

Theory & Practice

• In the mid-late 70s, there was a lot of research on schema design.

• Heavy emphasis on theory:
  • Functional dependencies
  • Multi-valued dependencies
  • Normal forms
  • Algorithms for automating schema design

• This theory explains how to transform bad schema into good ones.

• But seldom improves on intuition.

• Research on E/R models came later.

|< < 5 > >|