Project 1

Product- name, color, seller, sizes available, quantity available, cost, current discount, place of origin for delivery calculations, isFeatured, popularityIndex, avgratings, totalratings, reviews for ratings, review country, isOnSale, categories, brands, images, questions with answers about the products, description, tags, related products id

Customer- gender, dob, city, pw, name, email, delivery addresses, contacts, current and prev orders, payment info saved

Orders- status- cancelled/completed/ordered/packed/shipped/delivered, deliveryexpectation/deliverydate, orderdate

Seller- Name, mobile no, password, categories of products provided

ANS:-

CREATE TABLE product (name varchar(20),color varchar(10),seller int(10),size available int (20),cost int(10),current discount int(5),place of origin for delivery calculations varchar(20),popularity index varchar(50),avgratings float(10),total ratings float(10),review country varchar(30),isonsale varchar(20),categories varchar(50),brands varchar(30),questions with answers abiut the products varchar(1000),

INSERT INTO product VALUES ( 'manii','black',1,'m',500,25%,'hyderabad',flipcart.com,3.9,4.0,'india','yes','shirt','greneker','how many days quality is live')

INSERT INTO product VALUES ('sharmii','white',2,'s',1000,27%,'rajhumundry',amazon.com,4.1,4.2,'US','yes','chudidhar','how much length is available')

INSERT INTO product VALUES('ashritha','blue',3,'xs',600,15%,'draksharama',shoppee.com,3.5,3.7,'pakisthan','yes','jeans','prana','how much elastic is this')

INSERT INTO product VALUES ('madhu','pink','kakinada',flipcart.com,4.2,4.5,'iran','yes','frocks','epiklo','how much long is this')

INSERT INTO product VALUES ('priya','orange','dwarapudi',amazon.com,4.5,4.7,'ukrane','yes',night suits','adidas','the quality is same as in picture or not')

CREATE TABLE Customer (gender varchar(10),dob int(30),city varchar(50),password varchar(10),name varchar(50),email varchar(50),delivery address varchar(100), contacts int(20),

INSERT INTO customer VALUES ('male','30-06-2000','hyderabad','manii@02','manii','[email protected]','hyderabad hostel street srnagar',6304199250)

INSERT INTO customer VALUES ('female','23-03-2001','rajhumundry','sharmii@03','sharmii','[email protected]','rajhumundry highschool street ',6302543012)

INSERT INTO customer VALUES ('female','29-12-2002','draksharama','asrii@05','ashritha','[email protected]','draksharamam masid center ',9959353890)

INSERT INTO customer VALUES ('female','21-05-2001','kakinada','madhu@07','madhu','[email protected]','kakinada market center',9688234876)

INSERT INTO customer VALUES ('female','27-04-2002','dwarapudi','priya@09','priya','[email protected]','dwarapudi main road near market center',7981625207)

CREATE TABLE Orders(status varchar(50)

INSER INTO orders VALUES (cancelled,completed,packed,shipped,delivered,delivery expectation,delivery date,order date)

CREATE TABLE seller(name varchar(50),mobile int(20),password int(20),categories of products provided varchar(50)

INSERT INTO seller VALUES('raju',9953762389,'raju@089','shirts')

INSERT INTO seller VALUES('kumari',6305678423,'kumari@134','dresses')

INSERT INTO seller VALUES('prasad',7982536308,'prasad@897','frocks')