Table of Contents
Conceptual Design Using the Entity-Relationship
(ER) Model
Overview of Database Design
ER Model Basics
ER Model Basics (Contd.)
ER Model Basics (Contd.)
Cardinality Constraints
Translating ER Diagrams with Key Constraints
Participation Constraints
Participation Constraints in SQL
Weak Entities
Translating Weak Entity Sets
ISA Hierarchies
Translating ISA Hierarchies to Relations
Conceptual Design Using the ER Model
Entity vs. Attribute
Binary vs. Ternary Relationships
Constraints Beyond the ER Model
Summary of Conceptual Design
Summary of ER (Contd.)
|