Project 2
db.customer.insertMany([
{
_id: 1,
customer_id: 1,
customer_fname:'akshay',
customer_lname:'pandhare',
customer_dob:2000,
customer_address:'waluj',
customer_city:'Sambhajinagar',
is_premium: 1,
customer_contactno:9567546422,
},
{
_id: 2,
customer_id: 2,
customer_fname:'dipali',
customer_lname:'Bhosle',
customer_dob:1999,
customer_address:'Kirnapura',
customer_city:'Sambhajinagar',
is_premium: 0,
customer_contactno:9552545652,
},
{
_id: 3,
customer_id: 3,
customer_fname:'Rahul',
customer_lname:'kawale',
customer_dob:1998,
customer_address:'Ch.Shivaji nagar 1',
customer_city:'Sambhajinagar',
is_premium: 0,
customer_contactno:8043403893,
}
]);
db.cart.insertMany([
{
_id: 1,
cart_item_qty: 2,
product_id: 102,
customer_id: 1
},
{
_id: 2,
cart_item_qty: 1,
product_id: 201,
customer_id: 2
},
{
_id: 3,
cart_item_qty: 1,
product_id: 202,
customer_id: 3
}
,
{
_id: 4,
cart_item_qty: 1,
product_id: 501,
customer_id: 2
}
,
{
_id: 5,
cart_item_qty: 1,
product_id: 401,
customer_id: 3
}
]);
db.categories.insertMany([
{
_id:1,
categroy_name: 'Home Applicances',
},
{
_id:2,
categroy_name: 'Computers, Laptop and Mobiles',
sub_categories: ['Computers', 'Laptops', 'Mobiles']
},
{
_id:3,
categroy_name: 'Books',
sub_categories: ['Fiction', 'Biography', 'Fantacy Fiction','Non Fiction']
},
{
_id:4,
categroy_name: 'Fasion',
sub_categories: ['mens', 'womens']
},
{
_id:5,
categroy_name: 'Games and Consoles',
sub_categories: ['titles', 'console']
}
]);
db.products.insertMany([
{
_id:1,
product_name: 'Laptop',
product_model: 'C201',
product_brand: 'HP',
product_segments: ['Computers', 'Laptops'],
product_cost: 100000,
categroy_name: 'Computers, Laptop and Mobiles'
},
{
_id:2,
product_name: 'Smart Phone',
product_model: 'C202',
product_brand: 'Google',
product_segments: ['Mobile', 'Android'],
product_cost: 60000,
categroy_name: 'Computers, Laptop and Mobiles'
},
{
_id:3,
product_name: 'Lord of the Rings',
product_model: 'C501',
product_segments: ['Book', 'Novels'],
product_cost: 1500,
categroy_name: 'Books'
},
{
_id:4,
product_name: 'Pokemon Scarlet',
product_model: 'C701',
product_segments: ['pokemon', 'gen9'],
product_cost: 4500,
categroy_name: 'Games and Consoles'
},
{
_id:5,
product_name: 'Nintendo Switch',
product_model: 'C702',
product_segments: ['console'],
product_cost: 30000,
categroy_name: 'Games and Consoles'
},
]);
db.orders.insertMany([
{
_id: 1,
product_name: 'Nintendo Switch',
customer_id: 1,
order_qty: 1,
order_status: 'Delivered',
order_date: new Date('2022-11-15')
},
{
_id: 2,
product_name: 'Pokemon Scarlet',
customer_id: 2,
order_qty: 2,
order_status: 'Dispatched',
order_date: new Date('2022-11-27')
},
{
_id: 3,
product_name: 'Lord of the Rings',
customer_id: 3,
order_qty: 1,
order_status: 'Delivered',
order_date: new Date('2022-11-10')
},
{
_id: 4,
product_name: 'Smart Phone',
customer_id: 1,
order_qty: 1,
order_status: 'cancelled',
order_date: new Date('2022-11-18')
},
{
_id: 5,
product_name: 'Laptop',
customer_id: 1,
order_qty: 1,
order_status: 'Dispatched',
order_date: new Date('2022-11-01')
}
]);
db.seller.insertMany([
{
_id: 1,
seller_name: 'Jethalal Gada',
seller_business: 'Gada Electronics',
seller_mobileno: 4567891230,
seller_address: 'Andheri',
seller_city: 'Mumbai'
},
{
_id: 2,
seller_name: 'Ankur Kumar',
seller_business: 'ABC Sports and Fasion',
seller_mobileno: 7890123456,
seller_address: 'Connaught Place',
seller_city: 'Delhi'
}
]);
db.catlog.insertMany([
{
seller_name: 'Jethelal Gada',
product_name: 'Smart Phone',
product_qty: 10,
},
{
seller_name: 'Jethelal Gada',
product_name: 'Laptop',
product_qty: 5,
},
{
seller_name: 'Ankur Kumar',
product_name: 'Pokemon Scarlet',
product_qty: 20,
},
{
seller_name: 'Ankur Kumar',
product_name: 'Nintendo Switch',
product_qty: 15,
}
]);
QUESTIONS:
A1.
db.products.aggregate([{$
A2.
db.customers.aggregate([{$
A3.
db.order.aggregate([{$group:{_
A4.
db.customers.aggregate([{$
A5.
db.getCollection('seller').
$lookup:
{
from:'customer',
localField:'sel_city',
foreignField:'cust_city',
as:'customerdetails'
}
},
{
"$sort":{
"products_sold":-1
}},
{ $match : { "customerdetails" : { $ne : []}}},
]);