First of all, thank you for the explanation. I have a bit of confusion. I cannot seem to imagine the document structure differently for option B and C. What I am thinking is like this for both options,
{
"_id": ObjectId("customer_id"),
"name": "Customer Name",
"contactInfo": "Contact Information",
"accountInfo": "Account Information",
"transactions": [
{
"_id": ObjectId("transaction_id"),
"amount": 100.00,
"date": ISODate("2023-01-01T00:00:00Z"),
// Other transaction-related fields
},
// Additional transactions
]
}
Can you please give me the one example for option B and C according to your understanding?
I see. However, won’t there be a possibility of the transactions array going out of bound? Considering that, option A seems best to me. Can you please explain this?
Thank you for your kind response and time.