Database creation Theory
I work for a company that makes jewelry. They need to easily be able to order different stones, and gold/silver as well as the labor required per item number.
I am very new to databases so I need some help just figuring out how to create this. Since there are a bunch of different stones to order depending on the product...Should I make a seperate field for each type of stone.. or should there be one filed called stones and each entry within it would be a different stone?
the problem I see is that I have to type the style number in a field. so I would have the style number and it would need to be matched up with 7 different stones for example.
Any assistance is greatly appreciated! Thanks,