Originally posted by artemide
Can you be more specific:
What's the meaning of it all?
Do already have a start?
Are there some errors?
If you will give more details I will try to give you a helping hand.
You must have some idea of what you want...
I assume you will need several tables which have:
customers - Would contain all of your customer info
products - Would contain all of your product info
transactions - Would be the intersection table containing transaction info (customer and product id's as keys)
Those are the base tables you could not be without - You will most likely want some more tables. As the previous post stated you need to come up with some ideas b/c no one is going to build it for you.