L5 - ER Modeling

L5 - ER Modeling - ER Modeling Data modeling ER model...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
ER Modeling Data modeling ER model Entities Attributes Relationships 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Learning Objectives Benefits of modeling ER model Entities, relationships, attributes ER model vs. other models (process, etc.) Building an ER model 2
Background image of page 2
ER Modeling Logical Data Model Is a method for designing a system with a focus on data Purpose Helps optimize the design Creates a representation of the data requirements and rules for the enterprise Provides a way to communicate the design 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ER Modeling An entity-relationship model (ER) is a detailed, logical representation of the data for an organization or business Entities: distinguishable objects (suppliers, parts) Relationships: associations among entities Attributes: properties of entities and their relationships (customer name, customer address) ER Diagram: a graphical representation of an ER model Notation The original is Chen, another is “Crow’s Foot”, another IDEF 4
Background image of page 4
ER Modeling Entities Is a person, place, object, event or concept about
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 20

L5 - ER Modeling - ER Modeling Data modeling ER model...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online