|< < 3 > >|

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.

|< < 3 > >|