This serves as a market place to buy Mobiles online. APPLICATION NAME: ONLINE STORE MANAGEMENT SYSTEM PROBLEM STATEMENT: Online shopping is a form of electronic commerce which allows consumers to directly buy goods or services from a seller over the Internet using a web browser. Consumers find a product of interest by visiting the website of the retailer directly or by searching among alternative vendors using a shopping search engine, which displays the same product's availability and pricing at different e-retailers. customers can shop online using a range of different computers and devices, including desktop computers, laptops, tablet computers and smartphones.In order to design the data base for this application we need to bear in mind that i. customers – people who buy things in our store, and ii. products – items people buy in our store.
REQUIREMENTS: To create table for
i. Product:it contains the features asid,name ii. Purchase:it contains the features asid,user_account_id iii. Customer:it contains the features asid,name, Email,Password iv. Purchase_item:it contains the features aspurchase_id,product_id, number_of_items, total_price: total price of the items in a cart