Designing Relational Databases

4/30/00


Click here to start


Table of Contents

Designing Relational Databases

Problems with Simple Relations

Example

Example (contd.)

Solution : alternative design

Decomposition

How can we make decomposition lossless?

Formally Stating..

Normalization using Functional Dependencies

Desirable Properties

BCNF

Example

Solution

BCNF Decomposition

Lossless Decomposition

Dependency Preservation

3NF : Third Normal Form

3NF : Definition

3NF : Algorithm

Examples : 7.2, 7.3, 7.8

Functional Dependencies (review)

Anomalies in a Relation (review)

Insert, Update and Delete Anomalies (review)

Fourth Normal Form (4NF)

Fourth Normal Form (4NF) - Example

Normal Forms

Homework #3 :Due date 4/11 in class : Hardcopy

 Author: bina

Email: bina@cse.buffalo.edu

Home Page: http://www.cse.buffalo.edu/~bina

Download presentation source