PizzaStack.github.io

Normalization

A process in which you eliminate redundancy and maintain data integrity.

Starting point (no normalization)

| SalesStaff | | — | | EmployeeID | | SalesPerson | | SalesOffice | | Age | | DOB | | Customer1 | | Customer2 | | Customer3 |

1st NF (Atomic values, No repeating Columns)

| SalesStaff | | — | | EmployeeID | | SalesPersonName | | Age | | DOB | | SalesOfficeStreet | | SalesOfficeCity | | SalesOfficeState | | SalesOfficeZip |

Customer
CustomerId
EmployeeId
CustomerName

2nd NF (Remove Partial Dependencies)

| SalesStaff | | — | | EmployeeID | | SalesPersonName | | Age | | DOB | | SalesOfficeID |

SalesOffice
SalesOfficeId
SalesOfficeStreet
SalesOfficeCity
SalesOfficeState
SalesOfficeZip

Customer
CustomerId
EmployeeId
CustomerName

3rd NF (Remove Transitive Dependencies)

| SalesStaff | | — | | EmployeeID | | SalesPersonName | | DOB | | SalesOfficeID |

SalesOffice
SalesOfficeId
SalesOfficeStreet
SalesOfficeZip

Customer
CustomerId
EmployeeId
CustomerName

This site is open source. Improve this page.