Sigh. Alright, so I'm designing my database, and I'm following along the rules of normalization; but I'm stuck.
I have many tables planned, with some relationships, and I'm making sure I write down primary keys and which table needs which foreign key.
While doing this, I realized that I have a situation where a field seems to need more than one value within it.
And I know that's very wrong, and it'll be a big pain later if I do it that way.
And I've got several tables that have the exact same problem.
What I've got is:
Clothing (Linked to MaterialDegen, Tools, Resources)
-Primary Key (Clothing)
I have tables like this, where they have required items and resources in order to be made.
Like for tools, if it's a silk dress, you have to have scissors, a sewing needle, and a loom.
I have a tools tables already, the problem is I can't put more than one tool id at a time into the clothing table.
I'm not really sure how to continue forward; I think I'm missing something.
These values will never change, just in case anyone asks.
I'd be so grateful for any help.
Page 1 of 1
2 Replies - 4178 Views - Last Post: 02 July 2012 - 07:53 AM
Replies To: MySQL DB design; stuck and need help!
Page 1 of 1