Entity-relationship approach to the conceptual schema design

  • Authors:
  • Hirotaka Sakai

  • Affiliations:
  • Hitachi Institute of Technology, Hitachi, Ltd. Tokyo, Japan

  • Venue:
  • SIGMOD '80 Proceedings of the 1980 ACM SIGMOD international conference on Management of data
  • Year:
  • 1980

Quantified Score

Hi-index 0.00

Visualization

Abstract

The purpose of this paper is to present a systematic approach to the conceptual schema design. The entity-relationship model is used as the conceptual schema model. The entity-relationship schema, a formal description of the model, is defined to explicitly state the dependency structures such as the functional dependencies, the transitive dependencies, and the hierarchical decompositions. Based upon the analysis of these structural properties, the schema is iteratively transformed into the refined form. The notion of the access weight matrix is also introduced as a measure to evaluate the schemas.