db.Borrowing.aggregate([
  {
    $lookup: {
      from: "Members",
      localField: "member_id",
      foreignField: "member_id",
      as: "member_info"
    }
  },
  { $unwind: "$member_info" },
  {
    $lookup: {
      from: "Books",
      localField: "ISBN",
      foreignField: "ISBN",
      as: "book_info"
    }
  },
  { $unwind: "$book_info" },
  {
    $project: {
      member_id: 1,
      "member_info.first_name": 1,
      "member_info.last_name": 1,
      "book_info.title": 1,
      date_borrowed: 1,
      due_date: 1,
      return_date: 1,
      fine_amount: 1
    }
  }
]);