943,322 Members | Top Members by Rank

Web Development > Databases > Database Design > dell.com shopping cart save feature
Ad:
Permalink
Feb 16th, 2002
0

dell.com shopping cart save feature

Expand Post »
Hmm... i've been looking for monitors at www.dell.com (the accessories section) and i noticed in the shopping cart area, they have a feature called save. What i think this does is that it adds something to their database (probably MS SQL Server). My question is, would each new account need a table for itself?

I was thinking of how they did this save feature (adds info to database), and am curious as to what method they did this. Do you think they have a different table for each account? Or 1 big table for multiple accounts or what? What would be the best way to accomplish their save feature?
Similar Threads
Reputation Points: 21
Solved Threads: 0
Junior Poster
AlPhA is offline Offline
175 posts
since Feb 2002
Permalink
Feb 17th, 2002
0

Re: dell.com shopping cart save feature

No no no! =) Having a table for each account would be like having a hard drive for each file on your computer. Very inefficient. Accounts, or information that's similar like it is stored in records - which is pretty much like a row in a table. So you can have a table called Customers, and in that table, you have a record for each customer.
Team Colleague
Reputation Points: 262
Solved Threads: 18
a.k.a inscissor
samaru is offline Offline
1,227 posts
since Feb 2002
Permalink
Feb 17th, 2002
0

Re: dell.com shopping cart save feature

Would that table have all the ordering history of the customer and their saved stuff? Or would one table be for the ordering history and another for their saved?
Reputation Points: 21
Solved Threads: 0
Junior Poster
AlPhA is offline Offline
175 posts
since Feb 2002
Permalink
Feb 18th, 2002
0

Re: dell.com shopping cart save feature

It all depends on the complexity of the application, and who organized it. The designer of the database can include all the information about the customer in one record if he/she wants. Whatever the situation may be, he has to worry about normalization (avoiding duplicate fields; making the database design efficient), etc. Thats why tables can relate, and it's why we have relational databases.
Team Colleague
Reputation Points: 262
Solved Threads: 18
a.k.a inscissor
samaru is offline Offline
1,227 posts
since Feb 2002
Permalink
Feb 19th, 2002
0

Re: dell.com shopping cart save feature

What would you do?
Reputation Points: 21
Solved Threads: 0
Junior Poster
AlPhA is offline Offline
175 posts
since Feb 2002
Permalink
Feb 21st, 2002
0

Re: dell.com shopping cart save feature

It would depend what data I had to store. In the applications that I've written myself, I've never used more than 8 tables. On forums, I usually use just 3 tables.
Team Colleague
Reputation Points: 262
Solved Threads: 18
a.k.a inscissor
samaru is offline Offline
1,227 posts
since Feb 2002

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Next Thread in Database Design Forum Timeline: Auto update columns?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC