Project 2
Customer
-----------
db.customer.insertMany([
{cust_id:1,f_name:"guna",l_name:"N",password:"gunana32",conect:"9893893839",gender:"M",address:"chennai,tamilnadu",email_id:"[email protected]", tags:["premium"]},
{cust_id:2,f_name:"raju",l_name:"bai",password:"hugubbsn",conect:"1234567860",gender:"M",address:"sivaji nager,mumbai",email_id:"[email protected]", tags:["normal"]},
{cust_id:3,f_name:"manish",l_name:"gunda",password:"gundarhh",conect:"8974673582",gender:"M",address:"old dehli,dehli",email_id:"[email protected]", tags:["premium"]},
{cust_id:4,f_name:"hari haran",l_name:"V",password:"hiidbsj",conect:"8934278492",gender:"M",address:"bangaloure,karnataka",email_id:"[email protected]", tags:["normal"]},
{cust_id:5,f_name:"john",l_name:"crishtapal",password:"js8sbsn",conect:"6473937483",gender:"M",address:"salem,tamilnadu",email_id:"[email protected]", tags:["premium"]},
{cust_id:6,f_name:"junior NTR",l_name:"reddy",password:"sjnudnw",conect:"8947364837",gender:"M",address:"madurai,tamilnadu",email_id:"[email protected]", tags:["premium"]},
{cust_id:7,f_name:"Ramchran",l_name:"reddy",password:"idnsmmm",conect:"7287792738",gender:"M",address:"marathalli,karnataka",email_id:"[email protected]" ,tags:["normal"]}
]);
admin
--------
db.admin.insertMany([
{_id:1101, username:"gunaseelan", password:"gunabab",seller_id:101},
{_id:1102, username:"thilak", password:"thilan",seller_id:102},
{_id:1103, username:"Chan", password:"hshnsn",seller_id:103},
{_id:1104, username:"Dhanashekar", password:"nisnbd",seller_id:104}
]);
seller
-------
db.seller.insertMany([
{seller_id:101,name:"bervin",passwors:"bers9292",storename:"bervin store", contect:"9892892882",email_id:"[email protected]",address:"varanasi"},
{seller_id:102,name:"isai",passwors:"bers9292",storename:"isai store", contect:"09393892",email_id:"[email protected]",address:"banalogure"},
{seller_id:103,name:"imrankan",passwors:"bers9292",storename:"imran sport store", contect:"9938392992",email_id:"[email protected]",address:"chennai"},
{seller_id:104,name:"critepal",passwors:"bers9292",storename:"cristal cemara store", contect:"9892892882",email_id:"[email protected]",address:"mumbai"},
{seller_id:105,name:"antony",passwors:"bers9292",storename:"antony store", contect:"8373892883",email_id:"[email protected]",address:"dehli"},
{seller_id:106,name:"dharun",passwors:"bers9292",storename:"dharun store", contect:"8392892382",email_id:"[email protected]",address:"gujarath"}
]);
product
---------
db.product.insertMany([
{pro_id:1012, name:"electronic",Quentity:50,tags:["hp pavilion 360"],price:76000},
{pro_id:1013, name:"sports",Quentity:40,tags:["maspuro"],price:450},
{pro_id:1014, name:"farnichar",Quentity:90,tags:["sofa set"],price:286000},
{pro_id:1015, name:"foot ware",Quentity:13,tags:["puna shose"],price:6999},
{pro_id:1016, name:"electronic",Quentity:12,tags:["motherbood"],price:16000},
{pro_id:1017, name:"electronic", Quentity:10,tage:["sony camera"], price:"450000"},
{pro_id:1018, name:"electronic",Quentity:8,tage:["sony camera max"], price:"45000"},
{pro_id:1019, name:"shoes",Quentity:3,tage:["man","adidas shoes"], price:"11000"},
{pro_id:1022, name:"electronic",Quentity:5,tage:["boat headse"], price:"750"}
]);
cart
-----
db.cart.insertMany([
{cart_id:1001, pro_id:1017 ,brand:"sony",product:"electronic",tage:["sony camera"], price:"450000"},
{cart_id:1002, pro_id:1018 ,brand:"sony",product:"electronic",tage:["sony camera max"], price:"45000"},
{cart_id:1003, pro_id:1012, brand:"hp",product:"electronic",tage:["hp laptop"], price:"760000"},
{cart_id:1004, pro_id:1019 ,brand:"adidas",product:"shoes",tage:["man","adidas shoes"], price:"11000"},
{cart_id:1005, pro_id:1022 , brand:"boat",product:"electronic",tage:["boat headse"], price:"750"}
]);
order
-------
db.order.insertMany([
{_id:9001, cust_id:"1",name:"laptop" ,Quentity:2, price:76000, date:"2021-12-03"},
{_id:9002, cust_id:"2",name:"haedset" ,Quentity:3, price:750, date:"2022-03-10"},
{_id:9003, cust_id:"3",name:"mobil phone" ,Quentity:5, price:28999, date:"2022-05-12"}
]);
categories
-----------
db.categories.insertMany([
{cat_id:901, cat_name:"electronices", subcategory:{tags:["mobile phone","Laptops","fan","harddisc"]}, segments:"This all electronices thinkes"},
{cat_id:902, cat_name:"Footware", subcategory:{tags:["formal footware","sports footware","casual footware","leather footware"]}, segments:"Footware in all type of shose"},
{cat_id:903, cat_name:"cloth", type:"M", subcategory:{tags:["formal shorts","formal pant","jeans pant","casual shorts"]}, segments:"All type of cloths in our good colthsin our stores"},
{cat_id:904, cat_name:"Books", subcategory:{tags:["pome book","histry book","current affires book","maths book"]}, segments:"The all Book type in our shopes"}
]);
delivary
---------
db.delivary.insertMany([
{del_id:5001, cust_id:1, pro_name:"hp laptop", date:"2021-12-06", shippingaddress:{store_name:"Guru store",street:"Nanthan 3rd_street",city:"varanasi",state:"varanasi"},
delivaryaddress:{street:"kk nager",city:"vadapalani",distric:"chennai",state:"tamilnadu"},
payment:{payment_id:8829928,pay:"payment paid",card:"card paymanet"},type_of_delivary:"alearty paid"},
{del_id:5002, cust_id:2, pro_name:"redmi note 11 pro", date:"2022-03-14", shippingaddress:{store_name:"sree mobiles",street:"Sivaji nager",city:"mumbai",state:"mumbai"},
delivaryaddress:{street:"sivaji nagare",city:"norht mumbai",distric:"mumbai",state:"Maharashtra"},
payment:{payment_id:7484738,pay:" paid",card:"saving card paymanet"},type_of_delivary:"alearty paid"},
{del_id:5003, cust_id:3, pro_name:"cloth", data:"2022-05-15", shippingaddress:{store_name:"raguram store",street:"malik street",city:"varanasi",state:"varanasi"},
delivaryaddress:{street:"manu nager",city:"old dehli",distric:"dehli",state:"New dehli"},
payment:{payment_id:7783777,pay:"payment paid",card:"card paymanet"},type_of_delivary:"alearty paid"},
{del_id:5004, cust_id:4, pro_name:"Footware", date:"2021-06-24", shippingaddress:{store_name:"lake store",street:"gandhi nager",city:"gandhi nager",state:"Gujarath"},
delivaryaddress:{street:"Marathalli",distric:"bangloure",state:"Karanataka"},
payment:{payment_id:8829928,pay:"payment paid",card:"card paymanet"},type_of_delivary:"alearty paid"}
]);
1).
db.order.aggregate([ { $group:{_id:"name",average:{$avg:"$price"}}}]);
2).
db.customer.find({$count:"address","f_name"})
3).
db.order.aggregate([{$group:{_id:"name",total_order:{$sum:"$price"}}}]);
4).
db.customer.find({$count:"address","f_name"})
5).
db.seller.aggregate([{$group:{_id:"seller_name":{$match:"address"}}}])
db.order.aggregate([$sort:{order:1}:{$match:"address"}])