2NF (continued)

• No, it’s in 1NF only. Only candidate key is {part, wh}, and 2nd dependency violates 2NF.

• So what?

• We’re storing wh-addr once for each part stored at that warehouse.

• Solution: R1 (part, wh, qty) and R2 (wh, wh-addr)

• Are R1, R2 in 2NF?

Previous slide

Next slide

Back to first slide

View graphic version