E-COMMERCE DATABASE DESIGN ENTITY RELATIONSHIP DIAGRAM

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

Advertisements

About kishordgupta

A software developer
This entry was posted in DATABASE and tagged , , , , , , . Bookmark the permalink.

13 Responses to E-COMMERCE DATABASE DESIGN ENTITY RELATIONSHIP DIAGRAM

  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!

    TY..

  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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s