• Home
• System Analyze Method
  • An Imaginary System
  • System Analyze Q & A
  • Process Flow Diagram
  • Data Flow Diagram
• Network Architecture
  • Computer Network Model
  • Internet Technology
  • Client Server Architecture
• Data Architecture
  • Types of Database
  • Relational Database
  • Entity Relationship Model
  • Dimensional Data Model
• Data Modeling Tools
• Article Box
• About Me

• MS SQL Server 2008
• SSIS - MSDN Tutorials
• SSAS - MSDN Tutorials
• SSRS - MSDN Tutorials
• White Papers
• Q & A
• Webcasts

Entity Relationship Model

History of E-R Model

Component of E-R Model

• Entity
• Relationship
• Degree of Relationship
• Connectivity and Cardinality
• Associate Entity in Simple M:M
• Associate Entity in Complex M:M
• Eliminate Redundant Relationships
• Types of Relationships
• Attribute
• Identifier Attribute
• Descriptor Attribute

E-R Model Notation

Crow's Foot Notation

Employee Management System

Conceptual Data Model

Logical Data Model

Physical Data Model

Generalization Hierarchies

Accountability of Data Architect

Transform Data into Architecture

Relationship

Relationship is a connection between one or more entities in the Data Model. The interrelated entities must have relevant information. Relationship is not a data flow.

Download e-Book

Copyright © 2010 data-e-education.com. All rights reserved.

Terms of Use