If u r planning to design a e – commerce site , u have to take extra care for ur database design because site users can be both supplier and buyers, so it is complex to get a decent and simple view for that.

For every data base design first step is to make a entity relationship model, i think below model could give u a good idea

user could be buyer and seller both so a relationship must be maintained discreetly . Sellers provide products and buyers bought so products and buyers create order table. To complete successful order we need shippers and transaction from users.  users and transaction records need to be connected.

It is the basic skeleton of an e commerce database. To get a details idea u can see that here user interaction not implemented but as an example it provide a clear view on that.

hope, this effort will help you, to design an effective e commerce database

diagram courtesy by Ariful haque shisir

About kishor datta gupta

Graduate Research Assistant at University of Memphis Software Engineer at Silicon Orchard LTD. Former Research Assistant at Lamar University Former Software Engineer at Samsung R&D Institute Bangladesh Studies Ph.D. Computer Science at University of Memphis Studied Masters of Science in Computer Sciences at Lamar University Studied BSC in CSE at Khulna University of Engineering and Technology Studied HSC (completed) at Chittagang college 04-06 Studied High school at ST. Placid's High School'04 Studied Junior Secondary School at Saint Mary's School Lives in Memphis, Tennessee
This entry was posted in DATABASE and tagged , , , , , , . Bookmark the permalink.


  1. Anonymous says:

    thank you so much!!!

  2. Anonymous says:

    very helpful guide.

  3. Fernando says:

    I have been helpful

    thanks from Chile

  4. Anonymous says:

    You rock!
    Thx from Brazil

  5. Very helpful for my PHP project Thanx!


  6. Anonymous says:

    realy useful . Thanks!!!

  7. Olajide Olamide says:

    I will to have this and many more

  8. Anonymous says:

    Its healthy

  9. Olive says:

    thanks, its heplful 🙂

  10. Anonymous says:

    thanks a lot, this helped me to understand the practical with theory.

  11. Anonymous says:

    Thanks a lot. It was helpful

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s