Using the entity-relationship model to teach the relational model

  • Authors:
  • Kofi Apenyo

  • Affiliations:
  • Jackson State University, Jackson, Mississippi

  • Venue:
  • ACM SIGCSE Bulletin
  • Year:
  • 1999

Quantified Score

Hi-index 0.00

Visualization

Abstract

By far the two most important database models used in data management today are the relational and the entity-relationship models. In the database development cycle, entity-relationship modeling precedes the relational model work. Yet, in most textbooks and therefore in the classroom the relational model is presented before the entity-relationship model. The student is left to retrofit the entity-relationship model to the relational model. This paper advocates reversing this order of presentation so as to be in line with the database development cycle. The major benefit lies in taking advantage of this sequence to improve teaching the relational model. Assuming a prior treatment of conceptual modeling, examples and principles of the entity-relationship model are used to illustrate, elaborate, and even explain relational model concepts.