Table of Contents
CMPT 354 Database Systems and Structures
PPT Slide
Chapter 2 Objectives
Contents
Entity-Relationship Model
Entity
Entity Set
Attributes
Attributes
Relationship and Relationship set
Relationship and Relationship set
PPT Slide
PPT Slide
Degree of relationship set
Roles
Mapping cardinalities
PPT Slide
PPT Slide
Design Issues
Design Issues
Existence Dependencies
Total participation
Entity Set Keys
Weak Entity Sets
Weak Entity Sets
Extended Entity-Relationship Features
Specialization
Specialization
Generalization
Generalization
Generalization
Attribute Inheritance
Design Constraints
Aggregation
Aggregation
Represents ER model using tables
|
Author: Osmar R. Zaļane
|