Project 2

a)

{ _id: 1, idioma: "portuguese", quote: "A sorte protege os audazes" }
{ _id: 2, idioma: "spanish", quote: "Nada hay más surrealista que la realidad." }
{ _id: 3, idioma: "english", quote: "is this a dagger which I see before me" }

db.createUser(
{
user: "accountUser",
pwd: passwordPrompt(),
}
)

b)
{ $or: [ { <"Normal Member"> }, { <"Premium Member"> } ] }

c)
db.createView(
"prod_id",
"prod_name",
"price",
)

db.cart.aggregate( [
{
$addFields: {
CART: { $"Credit_cart", "$Debit_card" }
} }
] )

d)
db.createView.insertMany( [
{ prod_id:111, prod_name: "Mobiles", price: 20000 },
{ prod_id:112, prod_name: "Footwears", price: 500 },
{ prod_id:113, prod_name: "Blankets", price: 700 },
{ prod_id:114, prod_name: "Watches", price: 1000 },
{ prod_id:115, prod_name: "Wallets", price: 1000 },
{ prod_id:116, prod_name: "Shoes", price: 800 },
{ prod_id:117, prod_name: "Supplements", price: 2000 },
{ prod_id:118, prod_name: "Helmets", price: 3000 },
] )

e)
const products ({
prod_id:111,
prod_name: {
type: Iphone,
Available: { $or: [ { <"Stock"> }, { <Outofstock> } ] },
})
const products ({
prod_id:112,
prod_name: {
type: Adidas,
Available: { $or: [ { <"Stock"> }, { <Outofstock> } ] },
})
const products({
prod_id:113,
prod_name: {
type: Cotton,
Available: { $or: [ { <"Stock"> }, { <Outofstock> } ] },
})
const products({
prod_id:114,
prod_name: {
type: Boat,
Available: { $or: [ { <"Stock"> }, { <Outofstock> } ] },
})
const products({
prod_id:115,
prod_name: {
type: Leather,
Available: { $or: [ { <"Stock"> }, { <Outofstock> } ] },
})
const products({
prod_id:116,
prod_name: {
type: Nike,
Available: { $or: [ { <"Stock"> }, { <Outofstock> } ] },
})
const products({
prod_id:117,
prod_name: {
type: MuscleBlaze,
Available: { $or: [ { <"Stock"> }, { <Outofstock> } ] },
})
const products({
prod_id:118,
prod_name: {
type: Axor,
Available: { $or: [ { <"Stock"> }, { <Outofstock> } ] },
})

e)
{
prod_id:111,
model: [ "11", "12" , "12pro" ]
}
{
prod_id:112,
size: [ "8", "9" , "10" ]
}
{
prod_id:113,
size: [ "15", "16" , "17" ]
}
{
prod_id:114,
inch: [ "1.6", "1.8" , "2.0" ]
}
{
prod_id:115,
size: [ "6", "7" , "8" ]
}
{
prod_id:116,
size: [ "9", "10" , "11" ]
}
{
prod_id:117,
kg: [ "1", "2" , "5" ]
}
{
prod_id:118,
size: [ "S", "M" , "L" ]
}

g)

db.cart.aggregate( [
{
$addFields: {
CART: { $"Credit_cart", "$Debit_card" }
} }
] )

{
"accessLogs": [
{
"products": true,
"authSource": "customer",
"trackId": "571c390a7cea7e4dbf32b625",
"ipAddress": "123.45.0.1",
"logLine": "2019-07-25T19:14:42.484+0000 I ACCESS [conn2167] Successfully authenticated as principal jon-snow on admin from client 123.45.0.1:8080",
}

h)
db.createView.aggregate( [
{
$addFields: {
prod_id:119,
prod_name:"Television"
} }
] )

db.createView.aggregate( [
{
$addFields: {
prod_id:120,
products:"DSLR"
} }
] )

K)
db.createUser(
{
user: "accountUser",
pwd: passwordPrompt(),
roles: [ "readWrite", "Seller" ]
}
)

1.
db.order.aggregate(
[
{
$group:
{
_id: "$item",
avgAmount: { $avg: { $order: [ "$price", "$quantity" ] } },
avgQuantity: { $avg: "$quantity" }
}
}
]
)

3.
db.order.aggregate(
[
{
$group:
{
_id: { month: { $monthOfYear: "$month"}, year: { $year: "$month" } },
totalAmount: { $sum: { $multiply: [ "$price", "$quantity" ] } }
}
}
]
)

4.
db.customer.aggregate(
[
{
$city_of_name: {
}
},
{
$count: "city"
}
]
)