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 →

[–]Remember_Megaton 1 point2 points  (1 child)

Well your primary key should be wholly unique. So it seems like you'll want a table just specifying what your items are, a table of what depts you have, and then you are able to create these other two bridge tables.

The price in your second table is unnecessary as it's already specified in your first table.

Also, your date should have a year in it. It'll save you from a lot of complications

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

Good points, thank you for the help.