Ecommerce database design

Database design types

Few database design approach:

1. Relational database
• All products in a single table
• New table for a new type of product (ie. Pant, Shirt)
2. Entity Attribute Value (EAV)
3. Key-Value pair
4. NoSQL

Reference: https://www.practicalecommerce.com/A-Better-Way-to-Store-Ecommerce-Product-Information

Database design example

Sale Price vs Selling Price

Selling Price: It is the regular price (ie. BDT 10).
Sale Price: Price at some discount (ie. BDT 8).
Reference: https://www.englishforums.com/English/SalesPriceSalePriceSellingPrice-PertainsSelling/qmpzw/post.htm

Labels: SQL, Web development