Project 2

use Ecommerce

db.customers.insertMany([
{
cust_id:1,
prod_id:11,
gender:'male',
dob:05-06-2000,
city:'Madurai',
passord:'karthik123',
name:'Karthik',
type:'normal member',
email:'[email protected]',
del_address:'Madurai,Tamilnadu',
contacts:6578904523,
current_ord:'Shirt',
previous_ord:'jean',
payment_info:'Paid'
},
{
cust_id:2,
prod_id:13,
gender:'female',
dob:11-05-2001,
city:'chennai',
passord:'hema345',
name:'Hema',
type:'premium member',
email:'[email protected]',
del_address:'chennai,Tamilnadu',
contacts:9867459034,
current_ord:'saree',
previous_ord:'shoe',
payment_info:'pending'
}
]);

db.products.insertMany([
{
prod_id:11,
name:'Cargo pants',
color:'black',
seller_id:123,
size:28,
quantity:8,
cost:1500,
discount:50,
del_address:'Bangalore,Karnataka',
avg_rating:80,
onsale:'available',
category:fashion{sub_category:season sale},
brands:'Levis',
segments:'party wears',
descripyion:'wash gentle',
},
{
prod_id:13,
name:'saree',
color:'blue',
seller_id:223,
size:38,
quantity:18,
cost:2200,
discount:60,
del_address:'Chennai,Tamil nadu',
avg_rating:80,
onsale:'available',
category:Ethinic sale{sub_category:limited sale},
brands:'Apporva',
segments:'Ethinic wears',
descripyion:'Dry wash only',
}
]);

db.carts.insertMany([
{
cart_id:456,
quanity:1,
tol_cost:1500,
cust_id:1,
prod_id:11,
status:'check out',
payment_status:'paid',
},
{
cart_id:457,
quanity:1,
tol_cost:2200,
cust_id:2,
prod_id:13,
status:'login',
payment_status:'pending',
}
]);

db.orders.insertMany([
{
ord_id:10,
cust_id:1,
pro_id:11,
status:'check out',
tel_no:6578904523,
del_date:05-12-2022,
ord_date:01-12-2022,
},
{
ord_id:20,
cust_id:2,
pro_id:13,
status:'pending',
tel_no:9867459034,
del_date:07-12-2022,
ord_date:02-12-2022,
}

]);

db.admin.insertMany([
{
adm_id:001,
name:'Rahul',
password:'Rahul201',
email:'[email protected]',
add_prod_id:11,
category:fashion{sub_category:season sale}
},
{
adm_id:002,
name:'kishore',
password:'kishore657',
email:'[email protected]',
add_prod_id:13,
category:Ethinic sale{sub_category:limited sale},
}
]);

db.seller.insertMany([
{
sel_id:101,
cust_id:1,
name:'Muhil',
password:'Muhil789',
email:'[email protected]',
add_prod_id:11,
category:fashion{sub_category:season sale},
ord_status:'check out',
payment_status:'paid',

},
{
sel_id:102,
cust_id:2,
name:'Vignesh',
password:'Vignesh432',
email:'[email protected]',
add_prod_id:13,
category:Ethinic sale{sub_category:limited sale},
ord_status:'login',
payment_status:'pending',

}
]);

db.shipping details.insertOne({
shp_id:0452,
prod_id:11,
ord_id:10,
ord_status:'check out',
snd_date:03-12-2022,
del_date:05-12-2022,
bill_generated:'payment recieved'
});

Queries:

1)db.customers.aggregate({$avg:"cust_id"});

2)db.orders.find{{$ and:({$max:"orders"},{"customers_date"<60}});

3)db.orders.aggregate([{$group:{_id:"$this_month",order:{$sum:1}}}]);

4)db.customers.aggregate([{$group:{_id:"city_name",cust_name:{$count:1}}}]);