| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
06-09-11, 23:53
|
|
Registered User
|
|
Join Date: Jun 2011
Posts: 2
|
|
|
online shop
|
|
I want to develop online computer shop website.in which a number of products(computer,its parts) are available to purchase.but i am confuse to design database and its table.which is the best one strategy? - Store all products in one table
Store administrator and customer members in one table.
- store desktop and laptop computers in one table and mouse,printer etc are stored in another table
store administrator and customer in different tables
|
Last edited by Waseempki; 06-09-11 at 23:57.
|
06-12-11, 03:04
|
|
Banned
|
|
Join Date: Jun 2011
Posts: 40
|
|
If you are confused on how to design your database, then you would do well to use one of the many open source webshops available, or even a paid solution if that takes your fancy.
|
|
06-12-11, 10:40
|
|
Registered User
|
|
Join Date: Jun 2011
Posts: 2
|
|
|
Can you give me suggestion?
|
|
I want to do myself.I does not use existing one.Can you give me suggestion?
|
|
06-12-11, 11:48
|
|
Banned
|
|
Join Date: Jun 2011
Posts: 40
|
|
I would still suggest that you LOOK at a few open source solutions as they will best show you ways to do it.
Product databases can be extremely complex and I have yet to work with an eCommerce solution that uses a single table for products.
Lets say for example you have a graphics card for sale, but that card comes with several memory options. How are you going to handle that? Or you have a mouse, but that comes in several different colors... and so on...
For me, the best way to handle these kind of options is to have sub-products, a solution I created in 2003 and now used by Google, Mozilla and many others.
|
|
06-13-11, 17:42
|
|
Registered User
|
|
Join Date: Apr 2010
Location: London, England
Posts: 24
|
|
Hi
I suggest you use an online Database supplier to try to build your own - it will help you clarify your thinking about your design options.
Zoho used to offer something suitable that I think they are now calling Zoho Creator :-
https://www.zoho.com/creator/
If that doesn't work out I have listed a page of other choices on jy Database Answers Web Site :-
Online Databases
I would be interested in knowing how you egt on ;-0)
HTH
Barry Williams
London, England
|
|
06-14-11, 04:37
|
|
vaguely human
|
|
Join Date: Jun 2007
Location: London
Posts: 2,519
|
|
Quote:
Originally Posted by Waseempki
I want to do myself.I does not use existing one.
|
Why?
(this message is too short for some reason)
|
|
06-16-11, 09:58
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
|
|
Quote:
Originally Posted by Waseempki
I want to develop online computer shop website.in which a number of products(computer,its parts) are available to purchase.but i am confuse to design database and its table.which is the best one strategy? - Store all products in one table
Store administrator and customer members in one table.
- store desktop and laptop computers in one table and mouse,printer etc are stored in another table
store administrator and customer in different tables
|
Of these two options, the first is much preferable to the second.
__________________
If it's not practically useful, then it's practically useless.
blindman 
www.chess.com: "sqlblindman"
|
|
06-16-11, 12:55
|
|
Banned
|
|
Join Date: Jun 2011
Posts: 40
|
|
Quote:
Originally Posted by blindman
Of these two options, the first is much preferable to the second.
|
Oh yes, a single table full of NULLs.
I have yet to see one eCommerce platform where it would be either possible or practical to store all product data in a single table. It just could never work unless possibly you are selling a single product. Certainly not with computers and computer parts.
|
|
06-16-11, 13:09
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
|
|
Look up "Recursion".
Either an Adjacency model or Celko's Nested Set Model will be robust and efficient.
And by the way Backslider, where are teh codez?
Best way to design a table with start and end data
__________________
If it's not practically useful, then it's practically useless.
blindman
www.chess.com: "sqlblindman"
|
|
06-16-11, 13:22
|
|
Banned
|
|
Join Date: Jun 2011
Posts: 40
|
|
Quote:
Originally Posted by blindman
Look up "Recursion".
Either an Adjacency model or Celko's Nested Set Model will be robust and efficient.
|
Yes, these are both good techniques for handling product categories, but not product data. Looks like we need more tables.
Quote:
Originally Posted by blindman
|
I didn't see your currencies table......
|
|
06-16-11, 13:27
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
|
|
|
|
06-16-11, 14:33
|
|
Banned
|
|
Join Date: Jun 2011
Posts: 40
|
|
Quote:
Originally Posted by blindman
|
Well gee, lets stay on topic and perhaps you can show our friend your great single table eCommerce solution?
|
|
06-16-11, 14:50
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
|
|
No idea what you are talking about.
Where did I claim to have a great single table eCommerce solution?
Are you resorting to making stuff up now?
__________________
If it's not practically useful, then it's practically useless.
blindman
www.chess.com: "sqlblindman"
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
online shop
