Lecture 3

Using High-Level Conceptual Data Models for Database Design

*Entity-Relationship (ER) Model

*Entity-Relationship Diagram (ERD)

*Types of Relationships

*Notations (ER conventions)

*Resolving M:N relationship with attribute

Example: H.R. Department Business Scenario

Lecture 4

*Subtype & Supertype

*Arc (Exclusive OR notation in ERD)

*Arc vs. Supertype & Subtype

*Relationship Transferability (notation of nontransferable is included)

Review: Termination in this lesson