Project 1
USE ecommerce;
CREATE TABLE customer (
c_id INT PRIMARY KEY,
c_name CHAR(30),
email CHAR (30),
address CHAR (30),
number INT,
gender CHAR(1)
);
DESCRIBE customer;
INSERT INTO customer VALUES (1,'Ankit','[email protected]'
INSERT INTO customer VALUES (2,'Baljeet','baljeet111@
INSERT INTO customer VALUES (3,'Ashish','ashish34@gmail.
INSERT INTO customer VALUES (4,'veena','[email protected]'
INSERT INTO customer VALUES (5,'mohit','[email protected]
INSERT INTO customer VALUES (6,'Taniya','taniyamalik12@
INSERT INTO customer VALUES (7,'Gurpreet','gurpreet12@
SELECT *FROM customer;
CREATE TABLE seller(
s_id INT PRIMARY KEY,
s_name CHAR(30),
email CHAR(50),
contact INT,
address CHAR(50)
);
DESCRIBE seller;
INSERT INTO seller VALUES (101,'Shoki','shoki12@gmail.
INSERT INTO seller VALUES (102,'Ayush','[email protected]
INSERT INTO seller VALUES (103,'Amrit','amrit432@gmail.
INSERT INTO seller VALUES (104,'Shivam','shivam321@
INSERT INTO seller VALUES (105,'Bittu','bittu112@gmail.
INSERT INTO seller VALUES (106,'Karan','karan89@gmail.
INSERT INTO seller VALUES (107,'gopi','[email protected]
SELECT *FROM seller;
CREATE TABLE product (
p_id INT PRIMARY KEY,
p_name CHAR(30),
P_price DOUBLE,
product_wrnty CHAR(30),
stock_status INT ,
seller_id INT,
FOREIGN KEY (seller_id) REFERENCES seller(s_id)
);
DESCRIBE product;
INSERT INTO product VALUES (1001,'mobile','12000.00','2 year',12,103);
INSERT INTO product VALUES (1002,'pen','12.00','2 month',1012,102);
INSERT INTO product VALUES (1003,'biscuit','120.00','1 year',1200,101);
INSERT INTO product VALUES (1004,'Namkin','1200.00','1 year',102,103);
INSERT INTO product VALUES (1005,'Charger','790.00','2 year',10,105);
INSERT INTO product VALUES (1006,'Nackband','3500.00','1 year',20,104);
INSERT INTO product VALUES (1007,'shoes','4500.00','6 month',6,106);
INSERT INTO product VALUES (1008,'Bed','15600.00','1 year',22,107);
INSERT INTO product VALUES (1009,'Laptop','67000.00','2 year',90,107);
INSERT INTO product VALUES (1010,'Fan','2200.00','2 year',02,102);
SELECT *FROM product;
CREATE TABLE cart(
cart_id INT,
Quantity CHAR(30),
customer_id INT,
FOREIGN KEY (customer_id) REFERENCES customer(c_id),
seller_id INT,
FOREIGN KEY (seller_id) REFERENCES seller(s_id)
);
DESCRIBE cart;
INSERT INTO cart VALUES(501,'13',2,102);
INSERT INTO cart VALUES(502,'11',4,101);
INSERT INTO cart VALUES(503,'32',5,104);
INSERT INTO cart VALUES(504,'21',6,103);
INSERT INTO cart VALUES(505,'19',3,105);
INSERT INTO cart VALUES(506,'12',1,106);
INSERT INTO cart VALUES(507,'9',7,103);
INSERT INTO cart VALUES(508,'1',1,107);
SELECT *FROM cart;
CREATE TABLE orders(
order_id INT PRIMARY KEY,
contact INT,
address CHAR(50),
customer_id INT,
FOREIGN KEY (customer_id) REFERENCES customer(c_id),
seller_id INT,
FOREIGN KEY (seller_id) REFERENCES seller(s_id)
);
DESCRIBE orders;
INSERT INTO orders VALUES(1501,'9856694212','vpo-
INSERT INTO orders VALUES(1502,'985669772','vpo-
INSERT INTO orders VALUES(1503,'985669009','vpo-
INSERT INTO orders VALUES(1504,'985660095','vpo-
INSERT INTO orders VALUES(1505,'985669415','vpo-
INSERT INTO orders VALUES(1506,'985669411','vpo-
INSERT INTO orders VALUES(1508,'985669400','vpo-
INSERT INTO orders VALUES(1507,'985669090','vpo-
INSERT INTO orders VALUES(1509,'985669005','vpo-
INSERT INTO orders VALUES(1510,'985669890','vpo-
SELECT *FROM orders;
CREATE TABLE feedback(
fedback_id INT PRIMARY KEY,
customer_id INT,
FOREIGN KEY (customer_id) REFERENCES customer(c_id),
seller_id INT,
FOREIGN KEY (seller_id) REFERENCES seller(s_id),
star INT
);
DESCRIBE feedback;
INSERT INTO feedback VALUES(1,2,103,7);
INSERT INTO feedback VALUES(2,4,101,6);
INSERT INTO feedback VALUES(3,3,102,8);
INSERT INTO feedback VALUES(4,5,106,9);
INSERT INTO feedback VALUES(5,7,104,10);
INSERT INTO feedback VALUES(6,6,103,5);
INSERT INTO feedback VALUES(7,1,101,7);
INSERT INTO feedback VALUES(8,3,107,9);
INSERT INTO feedback VALUES(9,5,106,10);
INSERT INTO feedback VALUES(10,7,105,7);
INSERT INTO feedback VALUES(11,2,102,9);
SELECT *FROM feedback;