Intelligent logical design of relational databases

  • Authors:
  • Po-Jen Chuang;Frederick N. Springsteel

  • Affiliations:
  • Computer Science Department, University of Missouri, Columbia, Missouri;Computer Science Department, University of Missouri, Columbia, Missouri

  • Venue:
  • CSC '88 Proceedings of the 1988 ACM sixteenth annual conference on Computer science
  • Year:
  • 1988

Quantified Score

Hi-index 0.00

Visualization

Abstract

The research reported here concerns the use of well-behaved Entity-Relationship Diagrams (ERDs) in the logical design of database systems. Our results focus on prior ERD conditions for certain desirable logical designs, i.e. more “robust” relational scheme (e.g. in BCNF) than are obtained by ad hoc, unconditioned ERDs. The goal of our ERD-based design system is to ensure that enough conditions are present in the ERD as built interactively by the user of the demo system, so that a superior BCNF relational schema design is output by the usual subsequent transformation of the ERD.