Table of Contents
Database Management Systems & Programming
Class Outline
Weak Entities
PPT Slide
IS-A Supertypes-Subtypes
Steps to E-R Modeling
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
Solution to Q1
PPT Slide
Solution to Q2
PPT Slide
PPT Slide
Solution to Q1
PPT Slide
Solution to Q4
PPT Slide
Solution to Q5
Steps to E-R ModelTransformation
Developing an E-R Diagram
PPT Slide
Developing an E-R Diagram
PPT Slide
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Example of decomposing entities with a binary M:N relationship
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Developing an E-R Diagram
Case 11. Decomposing Weak Entities
Developing an E-R Diagram
Decomposing an IS-A Relationship
Decomposing an IS-A Relationship
Transforming Recursive Relationships
Transforming M:N Recursive Relationships
Decomposing Ternary relationships
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
Characteristics of Fields
Guidelines for Ideal Table Design
Common Errors in Database Design
The Well-Structured Database
The Challenge of Database Design: Conflicting Goals
|