question about database design

[Michael]

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

[Douglas Hawthorne]

Re: question about database design

"Michael" <no@spamplease. comwrote in message
news:a58dd0pnmg us6rpq3iftpp891 t19o7cbvg@4ax.c om...

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

Michael,

This is a normalisation question. Your data model is in first normal form
in that the attribute (or column), PriceGroup, has only one value for a row.

See www.dbdebunk.com for Fabian Pascal's opinion on normalism versus
denormalisation . However, his papers cost money.

If you are very, very keen, see C.J.Date's book, "An Introduction to
Database Systems" (Addison-Wesley-Longman). This book is not for the
faint-hearted DBA.

Douglas Hawthorne