470,868 Members | 1,904 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,868 developers. It's quick & easy.

question about database design

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
Jul 19 '05 #1
1 2203
"Michael" <no@spamplease.com> wrote in message
news:a5********************************@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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

22 posts views Thread by Nunaya | last post: by
3 posts views Thread by Yves Dhondt | last post: by
5 posts views Thread by Don Vaillancourt | last post: by
15 posts views Thread by designconcepts | last post: by
2 posts views Thread by Ed_P. | last post: by
6 posts views Thread by Bill44077 | last post: by
13 posts views Thread by John Kraft | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.