I am so confused on how to normalize the data? please help???

[coffayndtea]

http://i1253.photobucket.com/albums/...enk/pickme.jpg




so my first issue is I can even figure out the primary key (first guess was that it was the quantity but that brought along its own set of problems), on top of that, cost and total seems to be unrelated to anything unless i use a function(am i right on this at least?)

and can someone please explain how everything is interelated to each other, because i can not for the life of me figure it out

[pbaldy]

A normalized database would split that into two tables (more if you count tables for customers, products, etc). Basically your data through "G" would be in an "Orders" table, and the invoice number could be the primary key (there would only be one record for an order). You would also have an "Order Details" table that would include the invoice number plus your fields from "H" on (storing the total would typically not be done). That table would typically have an autonumber primary key, and would have a record for each product sold on an invoice. The two tables would be related one-to-many by the invoice number.

[coffayndtea]

That table would typically have an autonumber primary key, and would have a record for each product sold on an invoice.

I dont understand this part...I am sorry english is not my first language