Project 2

---PROJECT-2---

db.customer.insertMany([
{
_id: 1,
customer_id: 1,
customer_fname:'Komal',
customer_lname:'gautam',
customer_dob:2005,
customer_address:'kanpur',
customer_city:'kanchannagar',
is_premium: 1,
customer_contactno:9755657890,
customer_email:'[email protected]'
},
{
_id: 2,
customer_id: 2,
customer_fname:'kanak',
customer_lname:'bhatri',
customer_dob:2006,
customer_address:'unnao',
customer_city:'maolrod',
is_premium: 0,
customer_contactno:98678901,
customer_email:'[email protected]'
},
{
_id: 3,
customer_id: 3,
customer_fname:'Aniket',
customer_lname:'shukla',
customer_dob:2000,
customer_address:'udisha',
customer_city:'kanal',
is_premium: 0,
customer_contactno:566561234,
customer_email:'[email protected]'
}
]);

db.cart.insertMany([
{
_id: 1,
cart_item_qty: 3,
product_id: 201,
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: 6,
product_id: 801,
customer_id: 3
}
]);

db.categories.insertMany([
{
_id:1,
categroy_name: 'Home Applicances',
},
{
_id:2,
categroy_name: 't-shirt,' Laptop' and 'Make kit',
sub_categories: ['t-shirt', 'Laptops',faundation'),
},
{
_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: 'lift Scarlet',
product_model: 'C701',
product_segments: ['lifts', 'gen9'],
product_cost: 4500,
categroy_name: 'Games and Consoles'
},
{
_id:5,
product_name: ' microSwitch',
product_model: 'C702',
product_segments: ['console'],
product_cost: 30000,
categroy_name: 'Games and Consoles'
},
]);

db.orders.insertMany([
{
_id: 1,
product_name: 'micro Switch',
customer_id: 1,
order_qty: 1,
order_status: 'Delivered',
order_date: new Date('2022-11-15')
},
{
_id: 2,
product_name: 'lift Scarlet',
customer_id: 2,
order_qty: 2,
order_status: 'Dispatched',
order_date: new Date('2022-11-27')
},
{
_id: 3,
product_name: 'abs Rings',
customer_id: 9,
order_qty: 5,
order_status: 'Delivered',
order_date: new Date('2022-11-19')
},
{
_id: 4,
product_name: 'Smart Phone',
customer_id: 1,
order_qty: 1,
order_status: 'cancelled',
order_date: new Date('2023-10-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: 'Abishek gautam',
seller_business: ' Electronics',
seller_mobileno: 87977891230,
seller_address: 'romai',
seller_city: 'uttar pradesh '
},
{
_id: 2,
seller_name: 'Birju bharti',
seller_business: 'Kanti Sports and Fasion',
seller_mobileno: 8970123456,
seller_address: 'Connaught Place',
seller_city: 'mumbai'
}
]);

db.catlog.insertMany([
{
seller_name: 'Birju bahrti',
product_name: 'Smart Phone',
product_qty: 10,
},
{
seller_name: 'anju bharti',
product_name: 'Laptop',
product_qty: 5,
},
{
seller_name: 'Shudha gupta',
product_name: 'sakshamScarlet',
product_qty: 7,
},
{
seller_name: 'Nitu gupta ',
product_name: 'kashi Switch',
product_qty: 6,
}
]);