Profile

e-Catalog

Contact

Search

Cart

Entity Relationship Diagrams

Audience

Business and systems analysts, programmers, software engineers

Prerequisites

An understanding of relational database theory and of the role of analysts, designers, and database administrators

Course Aim

To describe the technique of entity relationship diagramming

Learning Objectives

Describe the typical stages in database modeling and design. Perform entity relationship analysis. Identify primary and foreign keys. Construct entity relationship diagrams using standard notations.

Topics Covered

Data modeling - Database principles - Database life cycle - Data models ERDs - Entities and relationships - Diagram construction - Exercise: Constructing an ERD - Alternative ER notations Attributes and keys - Primary and foreign keys - Data integrity - Exercise: Identifying primary and foreign keys Complex ER modeling - Advanced ER modeling - Normalization Case study - Deriving an ERD - Normalizing an ERD