question about database design

From: Michael <no_at_spamplease.com>
Date: Mon, 21 Jun 2004 11:03:51 +0200
Message-ID: <a58dd0pnmgus6rpq3iftpp891t19o7cbvg@4ax.com>

I have a question about the design of a database structure.

I have a customer that has a pricegroup:

Customer	PriceGroup
1234		2
3245		3

I have a collegue who like to create a price table this way:

Article PriceGroup1 PriceGroup2 PriceGroup3

A	14		12	7
B	24		23	19

I myself think this one is the better option:

Article	PriceGroup	Price
A	1		14
A	2		12
A	3		7
B	1		24
B	2		23
B	3		19

Can anyone help me what is the best solution? Maybe another one? :)

Thanks,

Michael Received on Mon Jun 21 2004 - 04:03:51 CDT