Database design: composing fully normalized tables from a rigorous dependency diagram

  • Authors:
  • Henry C. Smith

  • Affiliations:
  • Lockheed-Georgia Company, Marietta, GA

  • Venue:
  • Communications of the ACM
  • Year:
  • 1985

Quantified Score

Hi-index 48.22

Visualization

Abstract

A new simplified methodology for relational-database design overcomes the difficulties associated with nonloss decomposition. It states dependencies between data fields on a dependency list and then depicts them unambiguously as interlinked bubbles and doublebubbles on a dependency diagram. From the dependency diagram, a set of fully normalized tables is derived.