Project 2

Ans 1. creating and inserting the field of the collections

1 use E_commerce

. show dbs

2

And we have mention all collecton and there filds at the below

db.customer.insertMany([
{
_id:5, name:
{fname:'hari', lname:'preet'},
address:
{village:'mangraura',dis:"Pratapgarh",state:"uttar_pradesh" },
status:["premium", "non_premium"], account:909090789
},
{
_id:6, name:
{fname:'Ajad', lname:'Kumar'},
address:{village:'Dilippur', dis:"Pratapgarh",state:"uttar_pradesh"} ,
status:["premium", "non_premium"], account:909090550
},

{
_id:3, name:
{fname:'Simran', lname:'jeet'},
address:{village:'Hadiya', dis:"Mijoram",state:"Panjab"} ,
status:["premium", "non_premium"], account:909090799
},
{_id:4, name:{fname:'Shonu', lname:'sood'}, address:{village:'Dombivaly', dis:"Kalyan",state:"Maharastra"}, status:["premium", "non_premium"], account:909090700}
])

db.seller.insertMany([
{ _ id : 10, name:"Gunjan_Tiwari", storeName:"Tiwari_Electronics",
address:{area:"sallory", dis:"Allahabad"}},

{_id:11,name:"Santosh_panday", Store_name:"Panday_collection",
address:{area:"sadar", dis:"Pratapgarh"}
},
{_id:12, name:"Manish_singh", Store_name:"singh_Furniture" ,
address:{area:"patty", dis:"SultanPur"}
}
]);

db.administrater.insertOne ([
{add_id:13, name:'MukeshAmbani'}]);

db.Categorey.insertMany([
{cat_id: 31, category:"Electronics"},
{cat_id: 32, category:"Clothes" } ,
{cat-id: 33, category:"backery" } ]) ;

db.product.insertMany([
{product_id:21,cat_id:31, brand: "Philips", segment:"fan", prise:2000},
{product_id:22, cat_id:31, brand:"boat" ,segment :"Headphone", prise:1200},
{product_id: 23, cat_id:31, brand:"sumsung", segment:"Tv", prise:15000},
{product_id:24, cat_id:32, brand:"levies", segment:"shirt", prise:"500"},
{product_id:25, cat_id:32, brand:"raymond", segment:"pant", prise:"1000"},
} ]);

db.cart.insert({cart_id:51, product_id: 21, customer_id:2,seller_id:10 }, { cart_id:52, product_id: 22, customer_id:5 seller_id:12})

db.payment.id({payment_id:61,customer_id:01, cart_id:51,} );

db.order.insert({ order_id:71,order_amount:500, cart_id:51,customer_id:01} )

db.recipt.insert( { reciept_id:81,payment_id:61, order_id:71, customer_id:01, order_amount:500})

db.checkout.insert({ checkout_id :91, customer_id: 01 ,order_id:71, checkout_status:"yes" } );

Ans1.

db.order.aggregate([{$group:{_id:"order_id", od_amount_avg:{$avg:"$order_amount"}}}])

Ans 2.

db.customer.find({$joining_date:{$lt:date({"25/11/2022"})}})

Ans 3.

db.recipt.aggregate([{$group:{_id:"recipt_id", sum_order:{$sum:order_amount}}}])

Ans 4.
db.customer.aggregate([{$group:{_id:"customer_id", num_of_city{$sum:"$city"}}}])

Ans 5.

db.customer.aggregate([{$group:{_id:"customer_id",same_city{$match:$city}}}])