More on E-R Modeling
Database Design Overview
Why Do Conceptual Modeling?
The Entity-Relationship Model
The Components of an E-R Diagram...
Components of the E-R Diagram
Very Basic Models
But, there’s more
Candidate and Primary Keys
Identifying the primary key
Practice
Character - Play Example
Composite Entities
Multi-valued Attributes
Practice...
Runner / Marathon Example
Weak Entity
Derived Attribute
Laboratory Example
Generalization
Super/Sub-Type Relationship
Relationship Degree
Modeling Hints and Tips
Final Practice
Next Class
Email: simpsons@vancouver.wsu.edu
Home Page: http://www.vancouver.wsu.edu/fac/simpsons/mis372/index.html
Download presentation source