db.borrowedBooks.insertOne({
  memberID: 'MEM002',
  ISBN: 'ISBN002',
  dateBorrowed: new Date('2024-02-05'),
  dueDate: new Date('2024-02-19'),
  returnDate: null,
  fineAmount: 50.0
});

db.borrowedBooks.aggregate([
  {
    $lookup: {
      from: 'member',
      localField: 'memberID',
      foreignField: 'memberID',
      as: 'memberDetails'
    }
  },
  { $unwind: '$memberDetails' },
  {
    $lookup: {
      from: 'book',
      localField: 'ISBN',
      foreignField: 'ISBN',
      as: 'bookDetails'
    }
  },
  { $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
    }
  }
]);