3.1 Purpose of the Entity-Relationship Model (ER)
The entity-relationship (ER) model was developed by Peter Chen in 1976. The ER model facilitates database design by allowing the designer to express the conceptual properties of the database in an enterprise schema, which is an abstract model of the mini-world, the part of the real world that the database is intended to model. ER diagrams are used to express the structure of the model. Because it is independent of any database management system (DBMS), the enterprise schema will be valid regardless of the DBMS chosen, and it can remain correct even if the DBMS is changed. The diagrams are design tools that can be useful in implementing a variety of systems. We note that the discussion of the ...
Get Databases Illuminated, 4th 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.
