MIS 2101 Chapter Notes - Chapter 2: Entity–Relationship Model, Peter Chen, Software Engineering
Ultimate Guide to ER Diagrams
• What is an ER diagram?
o A visual representation of different entities within a system and how they relate
to each other
• History of ER Diagrams
o No standard way to model databases or business processes
o Peter Chen – introduced the ER model in one of his papers
▪ Focused on entities and relationships and introduced a diagramming
representation for database design as well
▪ Model inspired by the data structure diagrams introduced by Charles
Bachman
• ER Diagrams Usage
o ER Models in Database Design
▪ Used to design relational databases
▪ Entities in ER schema become tables, attributes and converted the
database schema
▪ Commonly used for database troubleshooting
o ER diagrams is software engineering
▪ Used in software engineering during the planning stages of the software
project
▪ Help identify different system elements and their relationships with each
other
▪ Often used as basis for data flow diagrams (DFDs)
▪
• ER Diagrams Symbols and Notations
o
o Three basic elements: entity, attribute, relationship
find more resources at oneclass.com
find more resources at oneclass.com