Normalization Practice Two

Case Two:

Inventory(PartNbr, {Warehouse, Location}, QOH, Weight, PartColor)

PartNbr --> Weight, PartColor
PartNbr + Warehouse --> QOH     QOH is Quantity On hand
Warehouse --> Location

Sample Data
PartNbr  Warehouse Location  QOH  Weight  PartColor
01       500       NW        135   11.75  Blue
01       600       SW        210   11.75  Blue
01       800       East      192   11.75  Blue
02       500       NW         75    2.50  Red
02       800       East       45    2.50  Red
03       500       NW        290   21.35  Green
03       600       SW         83   21.35  Green

Which Normal form is the Inventory table in?

 
Repeating Groups
Partial Key Dependencies
Transitive Dependencies

Solution for Number Two

Parts(PartNbr, Weight, PartColor)

InStock(PartNbr, Warehouse, QOH)

Warehouse(Warehouse, Location)

Another layout for the Part data.

PartNbr  Weight  PartColor Warehouse Location  QOH
01        11.75  Blue      500       NW        135
                           600       SW        210
                           800       East      192
02         2.50  Red       500       NW         75
                           800       East       45
03        21.35  Green     500       NW        290
                           600       SW         83

This format makes it easier to see the repeating groups

Next Practice