Re: question about database design

"Michael" <no_at_spamplease.com> wrote in message news:a58dd0pnmgus6rpq3iftpp891t19o7cbvg_at_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

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 Received on Mon Jun 21 2004 - 12:04:24 CEST