ER Model Components
1
,ER Model
• The ER model defines the conceptual view of a database.
• It works around real-world entities and the associations among them.
• At view level, the ER model is considered a good option for designing
databases.
2
,WHY ER Model
• ER Models in Database Design
• They are widely used to design relational databases. The entities in
the ER schema become tables, attributes and converted the database
schema. Since they can be used to visualize database tables and their
relationships it’s commonly used for database troubleshooting as well.
• ER diagrams in software engineering
• Entity relationship diagrams are used in software engineering during
the planning stages of the software project. They help to identify
different system elements and their relationships with each other. It is
often used as the basis for DFD’s as they are commonly known.
3
, Components of ER Model
• Components:
• Entity
• Attributes
• Relationships
4
1
,ER Model
• The ER model defines the conceptual view of a database.
• It works around real-world entities and the associations among them.
• At view level, the ER model is considered a good option for designing
databases.
2
,WHY ER Model
• ER Models in Database Design
• They are widely used to design relational databases. The entities in
the ER schema become tables, attributes and converted the database
schema. Since they can be used to visualize database tables and their
relationships it’s commonly used for database troubleshooting as well.
• ER diagrams in software engineering
• Entity relationship diagrams are used in software engineering during
the planning stages of the software project. They help to identify
different system elements and their relationships with each other. It is
often used as the basis for DFD’s as they are commonly known.
3
, Components of ER Model
• Components:
• Entity
• Attributes
• Relationships
4
