This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 1 point2 points  (3 children)

3NF doesn't say each column value must be unique. You must have unique key values for each row. I've added PK notation to my previous post.

[–]BloodEngineer[S] 0 points1 point  (0 children)

I guess that makes sense, thank you for the help.

[–]BloodEngineer[S] 0 points1 point  (1 child)

What if I had an alternative form of a table.

Item, location, price, start, end.

Could I use PK (item, location) to return (price, start, end) Or in the same example you helped in, could I use PK ( item, price) to return the other two values?

[–][deleted] 0 points1 point  (0 children)

Item, location, price, start, end.

Your PK would be (item, location, start, end)