Project 1

Insert into seller values(1001,'Tanmay_Singh',840999302,'[email protected]','tanmay123','Electronics')
(1002,'Jayant_yadav',840139312,'[email protected]','jayant123','Clothing'),
(1003, 'Avedesh_Tiwari',843892749,'[email protected]','Avedes123','Mobile Store'),
(1004, 'Vidya_patil',843897492,'[email protected]','Vidya123','Skin_care_Products'),
(1005, 'Tanvi_Lakhde',888398842,'TanviLakh123@yahoo','Tanvi123','Furniture');

Insert into customer values(010,'Denmix','[email protected]','1994-03-30','Chatrapati-Chowk Nagpur','M','64Inch_LED_TV','Debit Card','Denmix123'),
(011,'Rocky','[email protected]','2001-04-14','Shivaji Nagar Aurangabad','M','T-shirt','COD','Rocky123'),
(012,'keiem','[email protected]','1997-03-19','Sec8 POE Jaipur','F','Washing_Machine','Credit Card','Keiem123'),
(013,'Danu','[email protected]','1992-09-23','Sivaji Nagar Delhi','F','Asus_Gaming Laptop','Debit card','Danu123'),
(014,'Snepher','[email protected]','1991-12-18','IT sec3 Hydrabad','M','I-phone 13','COD','Snepher123');

insert into admin(0001,'Shrikant',7830443922,'China_town Delhi','Fashions');

Insert into Ecom_site Values('ES001',010,0001,1002),
('ES002',011,0001,1001),
('ES003',012,0001,1003),
('ES004',013,0001,1004),
('ES005',014,0001,1005);

Insert into product values('PR0001','ES002','Jayant_yadav','Clothing','jeans_Pant','2000.00','Lee','8','43'),
('PR0002','ES004','Vidya_patil','Skin_care_Products','Skin_care kit','4000.00','Garnier','7','5'),
('PR0003','ES001','Tanmay_Singh','Electornics','64Inch_LED_TV','64000.00','SONY','9','23'),
('PR0004','ES005','TanviLakhde','Furniture','Dinning Table','24000.00','SkyWoods','7','10'),
('PR0005','ES003','Avedesh_Tiwari','Mobile Store','I-Phone 13 Pro','70000.00','I-Phone','8','1'),
('PR0006','ES001','Shrikant','Fashions','Black_Square Fas_spect','2000.00','Rolex','9','25');

Insert into Cart values('CRT001',010,'PR0002','4000.00'),
('CRT002',014,'PR0001','2000.00'),
('CRT003',012,'PR0005','70000.00'),
('CRT004',013,'PR0004','24000.00'),
('CRT005',010,'PR0003','64000.00');

Insert into Order_tab Values('ORD0001','CRT001','XYZ Nagpur','COD','8','2022-04-12','Delay Transport','2022-04-20'),
('ORD0002','CRT002','ZYS Hydrabad','Debit card','7','2022-06-03','Return','2022-06-05'),
('ORD0003','CRT003','YES Banglore','Credit Card','9','2022-09-10','Delivered ON TIme','2022-09-14'),
('ORD0004','CRT004','DBS Delhi','COD','7','2022-03-15','On_Way On_time','2022-03-20'),
('ORD0005','CRT005','LES Jaipur','Internet Banking','8','2022-09-24','Delivered In time','2022-09-25');