Question

Need an example of a database schema for an online or ecommerce store and an explanation of the how it functions

Answer 1

This Exanple of Database schema is so simple and just at a basic level:

Some basic requirements for the online store, for which this schema made for:

First of all user will register himself/herself on the portal,then there will a list of products which are available to buy. The store will have an inventory of products. Each product has a unique price, but this price should vary depending on sales. Customers can make orders for multiple products at a time, and should be able to see their order history. When the order has been completed, there should be a track and trace number.

Functions:

1)Registeration:

Every one on this online store will have his own account on which his register him/her self and share his information about his address Cell Number e.t.c.

2)Product Management:

After Registeration they will have a list of available products and he/she will start selcting items.

3)Order Management:

After selecting the products there will be a proper order is ready by adding the shippment charges or anything else.

4)Payment Management

After the completion of Order user will have to choose a payment method which could be cash on delivery or by Debit card(online).

5)Delivery System

After the whole work done by user the order will be given to the post office to deliver on the given address.

PLEASE GIVE US A THUMBS UP.

IF YOU HAVE ANY QUERY PLEASE COMMENT BELOW.