Table of Contents
Database Management Systems & Programming
Class Outline
Steps to E-R ModelTransformation
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Example of decomposing entities with a binary M:N relationship
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Transforming an E-R Model
Case 11. Decomposing Weak Entities
Transforming an E-R Model
Decomposing an IS-A Relationship
Decomposing an IS-A Relationship
Transforming Recursive Relationships
Transforming M:N Recursive Relationships
Decomposing Ternary relationships
Transforming an E-R Diagram
PPT Slide
Transforming an E-R Model
PPT Slide
Library Database Example
University Example
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
ER Modeling I handout - Q1
ER Modeling I - Q2
ER Modeling I - Q3
ER Modeling I - Q4
ER Modeling I - Q5
ER Modeling II - Q1
ER Modeling II - Q2
ER Modeling II - Q3
ER Modeling II - Q4
ER Modeling II - Q5
ER Modeling II - Q6
Class Outline
Transformation & Normalization
Database Design Problems
Database Design Problems
The Problem with Nulls
Database Design Problems
Normalization
Normalization
Rules for Normalization
Rules for Normalization
Rules for Normalization
Rules for Normalization
Rules for Normalization
First Normal Form
Handling multi-valued attributes: Incorrect Solutions
Handling multi-valued attributes: Correct Solution
Handling Repeating Groups
Second Normal Form
Removing Partial Dependencies
Third Normal Form
Removing non-key Transitive Dependencies
Normalization Example: Video Store
Normalization Example: Video Store
Is the Video store in 1NF?
Video Store: 1NF (cont’d)
The Video Store is now in 1NF
Is the Video Store in 2NF?
Is the Video Store in 3NF?
The Video Store is now in 3NF
Normalization Example: ARTIST
PPT Slide
Checking Transformed ER Model
PPT Slide
PPT Slide
Normalization Exercises
Normalization Exercises
Normalization Exercises
Normalization Exercises
Normalization Exercises
Normalization Exercises
Conflicting Goals of Design
Characteristics of Fields
Guidelines for Ideal Table Design
Common Errors in Database Design
The Well-Structured Database
For Week 6
|
Author: Reference Services
Email: iwhyte@lib.uwo.ca
Other information:
ER Transformation & Normalization Lectures
Download presentation source
|