Database design for E commerce web site
-
Hi i am working for a E-Commerce website, i want to know about what are all the table that are required to achieve the task
-
Hi i am working for a E-Commerce website, i want to know about what are all the table that are required to achieve the task
Hi... With my answer I can't able to explain the DB design. First you need to collect the requirements, It will be different as per the vendor and many constraints will be there. Only Check the links.... The Basics of Good Database Design in Web Development[^] eCommerceDatabse.png[^] Regards, GVPrabu
-
Hi... With my answer I can't able to explain the DB design. First you need to collect the requirements, It will be different as per the vendor and many constraints will be there. Only Check the links.... The Basics of Good Database Design in Web Development[^] eCommerceDatabse.png[^] Regards, GVPrabu
thanks for your reply.. i have a requirement doc but i am unable to understand that one thats y can u tell me the basic tables which are required to achieve the e-commerce project.. as per my understand 1)user may signup using facebook,twitter,google+.. 2)user interests and habits are need to be imported from social networking sites while signing up.. 3)user may refer the friends, and stored in different groups 4)search, results will be in sorted as user wish(interest, buying habit, friends recommendations...) 5)reviews, user may write the reviews, like the others reviews. these reviews are need to keep 6)rating.. 7)all like wish list, shopping cart,payment, delivery.. Thanks subbarao
-
thanks for your reply.. i have a requirement doc but i am unable to understand that one thats y can u tell me the basic tables which are required to achieve the e-commerce project.. as per my understand 1)user may signup using facebook,twitter,google+.. 2)user interests and habits are need to be imported from social networking sites while signing up.. 3)user may refer the friends, and stored in different groups 4)search, results will be in sorted as user wish(interest, buying habit, friends recommendations...) 5)reviews, user may write the reviews, like the others reviews. these reviews are need to keep 6)rating.. 7)all like wish list, shopping cart,payment, delivery.. Thanks subbarao
-
Thanks a lot....
-
Hi i am working for a E-Commerce website, i want to know about what are all the table that are required to achieve the task
-
Hi i am working for a E-Commerce website, i want to know about what are all the table that are required to achieve the task
You are in trouble. You need a basic understanding of the following skills - Reading and understanding requirements. - Creating designs - Creating data models - Creating databases And I expect that you are going to also need the following skills - Internet Security - Web design - Basic SQL - Intermediate Database management and SQL - Basic user security - Basic business retail knowledge You could probably start by learning how to create databases, create tables and use SQL to access them. That would probably take a week. Then learn about business retail and improve your requirement reading skills. No idea how long that will take you. The two above together can then be used to create some tables that are at least something like what is needed for the project.
-
thanks for your reply.. i have a requirement doc but i am unable to understand that one thats y can u tell me the basic tables which are required to achieve the e-commerce project.. as per my understand 1)user may signup using facebook,twitter,google+.. 2)user interests and habits are need to be imported from social networking sites while signing up.. 3)user may refer the friends, and stored in different groups 4)search, results will be in sorted as user wish(interest, buying habit, friends recommendations...) 5)reviews, user may write the reviews, like the others reviews. these reviews are need to keep 6)rating.. 7)all like wish list, shopping cart,payment, delivery.. Thanks subbarao
