On mapping ER and relational models into OO schemas

  • Badri Narasimhan
  • Shamkant B. Navathe
  • Sundaresan JayaramanEmail author
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 823)


The Entity-Relationship model (ER model) views data in the form of entities and relationships. The Object-Oriented model (OO model) views data as classes, types and their subtypes. A mapping procedure that considers various features of the ER model and transforms the ER schema and its associated relational schema into an OO schema is proposed. The mapping rules are illustrated with appropriate examples. A procedure for mapping constraints on the ER database into the OO schema is then discussed. Finally, OO representations are developed for ER schema operations.


Composite Attribute Constraint Class Instance Variable Transition Constraint Person Class 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    Booch, G., Object-Oriented Design with Applications, Benjamin /Cummings, Redwood City, California, 1991.Google Scholar
  2. [2]
    Chen, P.P., The Entity-Relationship Model — Towards a Unified View of Data, ACM Transactions on Databases, Vol 1, No 1, March 1976, pp. 9–36.CrossRefGoogle Scholar
  3. [3]
    Elmasri, R., and Navathe, S.B., Fundamentals of Database Systems, 2nd Ed., Benjamin/Cummings, Redwood City, California, 1994.Google Scholar
  4. [4]
    Lippman, S.B., C++ Primer, Addison-Wesley, Reading, Massachusetts, 1989.Google Scholar
  5. [5]
    Rumbaugh, J., Relations as Semantic Constructs in an Object-Oriented Language, OOPSLA, 1987, pp. 466–481.Google Scholar
  6. [6]
    Narasimhan, B., Navathe, S.B., Jayaraman, S., On Mapping ER Models to OO Schemas, Technical Report # SJ-PYI-9306, School of Textile & Fiber Engineering, Georgia Institute of Technology, Atlanta, GA 30332-0295.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1994

Authors and Affiliations

  • Badri Narasimhan
    • 1
  • Shamkant B. Navathe
    • 1
  • Sundaresan Jayaraman
    • 2
    Email author
  1. 1.Georgia Institute of TechnologyCollege of ComputingAtlanta
  2. 2.Georgia Institute of TechnologySchool of Textile & Fiber Engr.Atlanta

Personalised recommendations