10 The Enhanced Entity-Relationship (EER) Model

DOI: 10.1201/9781003314455-10


In the first several chapters of this book, we presented the entity-relationship (ER) diagram as a conceptual database tool. The approach we took in developing an ER diagram was to model reality for a user. Although we worked on the basics of the ER diagram, there are situations for which the basic model fails to completely describe the reality of the data to be stored. With the increase in the types of database applications, the basic concepts of ER modeling (as originally developed by Chen) were not sufficient to represent the requirements of more complex applications like generalizations and specializations (class hierarchies). An ER ...

Get Database Design Using Entity-Relationship Diagrams, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.