Normalization

Normalization

Rental (carReg, make, model, custNo, custName, rentalDate, outletNo, outletLoc)

1)

UNF

Rental (carReg, make, model, custNo, custName, rentalDate, outletNo, outletLoc)

2)

1NF – resolve repeating groups.

Rental (carReg, make, model, custNo, custName, rentalDate, outletNo, outletLoc)

3)

2NF – resolve partial dependencies.

Rental (carReg[FK], custNo, custName, rentalDate)

Car (carReg, make, model, outletNo, outletLoc)

4)

3NF – resolve transitive dependencies.

Rental (carReg[FK], custNo[FK], rentalDate)

Cutomer (custNo, custName)

Car (carReg, model[FK], outletNo[FK])

CarModel (model, make)

Outlet (outletNo, outletLoc)