| | |
database design for webstore with over 2000 products
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
0
#2 18 Days Ago
You need a table with product id , product name , description, price , coupon/discount ,etc .
•
•
Join Date: Mar 2004
Posts: 763
Reputation:
Solved Threads: 38
0
#4 18 Days Ago
So you can keep track of product discounts.
Just sit down and think what you need to know about your store. You need to know the product name, a description (maybe short and long), a price, quantity in stock, attributes. If you sell nothing but t-shirts, the attributes will be fairly simple. If you have a large variety of different products, you'll need a more complex system of storing product attributes, likely creating a few more tables.
Just sit down and think what you need to know about your store. You need to know the product name, a description (maybe short and long), a price, quantity in stock, attributes. If you sell nothing but t-shirts, the attributes will be fairly simple. If you have a large variety of different products, you'll need a more complex system of storing product attributes, likely creating a few more tables.
![]() |
Similar Threads
- Database Design Help (Database Design)
- Sales and Purchase DataBase Design (Database Design)
- Database Design feedback (absolute beginner here :) (Database Design)
- Help with contact/mailing list database design... (Database Design)
- Database design - subtypes and instances of an entity (Database Design)
- Database Design - Supertypes and Subtypes (Database Design)
- Database Design Advice (MySQL)
Other Threads in the Database Design Forum
- Previous Thread: Application of Database Recovery System
- Next Thread: New Web database
| Thread Tools | Search this Thread |






