There is an error on chapter 8 pg.228-229 of "Professional SQL Server 2000 Programming". The Third Normal Form explicitly states that no column can have any dependency on any other non-key column. Yet, the author chose to leave UnitPrice in the OrderDetails Table. UnitPrice obviously depends on PartNo, and should be located in the PartNo Table. What do you guys think?
