How to design the tables in mysql?

See more:

MySQL

Hi,

am getting confusion for designing table structures for the follwing requirement
i have to design table structures for packing material details

user will enter the number of bottles,bottle size,company name. based on these three values i need to get the available packing material names and thier quantities.

packing materials are

1.bottles(types:glass/pet bottles)
2.caps with company logo
3.printed lables(with company name and product name)
4.cartons(with company name,product name)
5.measuring cups(based on product name)
6.droppers(based on product name)
7.gum(common for every product)
8.tape rolls(common for every product)

for example user enters 10ml glass bottles,company name is XXXX

for 10ml bottles(below parameters will be change based on bottle size,if bottle size will change below parameters size will also change)

caps size must be 25mm
lable size should be 10x20
carton size should be 10x20x50

if user enters 10ml glass bottle and company name like xxx

my query result should be:

pm_name           size         qty          company name

glass bottle      10ml          1000         NA

pp caps           25mm          2000         xxx

printed lables    10x20         2000         xxx
(with productname)
cartons           10x20x50      3000         xxx
(with productname) 
gum               10             10          NA
 
measuring cups    50mm           20000       NA

tape rolls         xxx           20          NA

so how can i design the table please help me

thanks in advance