Is there anywhere that I can get help modelling my system into an efficient database model? I have tried a number of times to design out the tables and relationships but keep getting mixed up and running into problems. I shall post the outline here and any help or advice would be very much appreciated.
I have a stock room with items of stock.
These items of stock are used to create sets of product which are then shipped.
Given the length of the final product, I can make a judgement on the amount of each product a set that will be shipped, however this is not fixed.
Stock items can also be sold individually.
I receive an order from the sales department detailing the qty and lengths of sets to send. These orders can also, as stated before, be for individual items. ie not in sets / spares
I would like to be able to add sets to the database and edit the stock items and quantities associated with each set as I go.