Modeling Constraints
Single Value Constraints
Referential Integrity Constraints
Weak Entity Sets
The Relational Data Model
Terminology
More Terminology
More on Tuples
Updates
From ODL to Relational Schema
Adding Non atomic Attributes
Set Attributes
Modeling Collection Types
Modeling Relationships
Option #1
Hint
Better Solution
Additional Issues
From E/R Diagrams to Relational Schema
PPT Slide
Entity Sets to Relations
Relationships to Relations
Handling Weak Entity Sets
Modeling Subclass Structure
Option #1: the ODL Approach
Option #2: the E/R Approach
Option #3: The Null Value Approach
Email: alon@cs.washington.edu
Home Page: http://www.cs.washington.edu/homes/alon
Download presentation source