Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2005-03-17 : 03:21:13
|
| hello,I need some advice on creating an invoice table as well as a shopping cart table.I am wondering which would be a better design, My users woudl be allowed to purchase a maximum of 6 items for his/her shopping cart/Invoice table1. To keep all items in the shopping cart in the table columns item1, item2, item3, item4, item5, item6 or 2. To Create a seperate entry for each and purchase and reference it by a unique shopping IDKnowing that the user could pick one item NORMALLY at a time.I could use a union all statement to reference option1 above. But which would be a better design for both a shopping cart and invoice tablethanksAfrika |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-17 : 04:29:34
|
| I vote 2.The view thing can be used to transpose the data from 1->2 or 2->1.rockmoose |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-17 : 04:35:27
|
| I vote 2 as well. Because I'll also bet that the "6 item" limit is changed at some future point!Kristen |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-03-17 : 04:42:49
|
| Thank you all for voting.As the chairman of this election, i hereby declare option 2 as the winner of my case study. Once again, we would like to express our sincere appreciation for your sincere votes, and successful installation of option 2 to officeBest wishesAfrika :- ) x2 |
|
|
|
|
|
|
Quick Advice on Invoice table