s.fox
January 29th, 2009, 01:19 PM
Hi,
I am currently working on a database design for a project. Basically the team and myself have a split of opinion on which table design is better.
We have the scenario where our products cost different amounts depending on the company that places an order. We have around 50 companies that will be ordering from ourselves and 200 different products.
To allow better understanding of the problem I have built a spreadsheet with sample data placed into both of the different designs. I have attached the spreadsheet in this post.
Personally I think design 2 is better than design 1 because design 2 would need a new column added every time a product is added. I also believe that it would be bad practice to have the product ID as a column heading in the table. The reason for the split of opinion in the team is that design 2 would need many many more rows than design 1.
I suppose what I am asking is:- Which design would be best to go with and why?
Many thanks for taking time out to have a look.
Ash R
P.S. If any clarification is needed please don't hesitate to ask.
I am currently working on a database design for a project. Basically the team and myself have a split of opinion on which table design is better.
We have the scenario where our products cost different amounts depending on the company that places an order. We have around 50 companies that will be ordering from ourselves and 200 different products.
To allow better understanding of the problem I have built a spreadsheet with sample data placed into both of the different designs. I have attached the spreadsheet in this post.
Personally I think design 2 is better than design 1 because design 2 would need a new column added every time a product is added. I also believe that it would be bad practice to have the product ID as a column heading in the table. The reason for the split of opinion in the team is that design 2 would need many many more rows than design 1.
I suppose what I am asking is:- Which design would be best to go with and why?
Many thanks for taking time out to have a look.
Ash R
P.S. If any clarification is needed please don't hesitate to ask.