db.borrowedbooks.aggregate([
{
    $lookup: {
        from: "member",
        localField: "memberID",
        foreignField: "memberID",
        as: "memberDetails"
    }
},
{
    $lookup: {
        from: "book",
        localField: "ISBN",
        foreignField: "ISBN",
        as: "bookDetails"
    }
},
{
    $unwind: "$memberDetails"
},
{
    $unwind: "$bookDetails"
},
{
    $project: {
        _id: 0,
        memberID: "$memberDetails.memberID",
        firstName: "$memberDetails.firstName",
        lastName: "$memberDetails.lastName",
        bookTitle: "$bookDetails.title",
        dateBorrowed: 1,
        dueDate: 1,
        returnDate: 1,
        fineAmount: 1
    }
}
])