db.createCollection("AUTHOR");
db.createCollection("BOOK");
db.createCollection("BOOKAUTHOR");
db.createCollection("MEMBER");
db.createCollection("BORROWEDBOOKS");
(GreeksforGreeks,2026)

2.2 db.AUTHOR.insertMany([
    {
        authorID: 205,
        firstName: "Mandla",
        lastName:"Mlotshwa"
    },
{
    authorID: 207,
    firstName: "Lerato",
    lastName:"Phiri"
}
]);

db.BOOK.insertMany([
    {
        ISBN:"2558411100206",
        title: "Kick Two Birds With One Ball",
        publicationYear:2026
        
    },
    {
        ISBN:"6595811100701",
        title: "Foundations of Cement Work",
        publicationYear:2027
    }
]);

db.BORROWEDBOOKS.insertMany([
  { memberID: 2005, 
    ISBN:"2558411100206", 
    dateBorrowed:"05/2026",
    dueDate:"06/2026", 
    returnDate:"05/2026", 
    fineAmount:50 },
    
  { memberID: 2027, 
    ISBN:"6595811100701", 
    dateBorrowed:"05/2026",
    dueDate:"06/2026", 
    returnDate:"05/2026",
    fineAmount:50 }
]);

db.BOOKAUTHOR.insertMany([
    {
    authorID:205,
    ISBN:"2558411100206"
    },
    {
    authorID:207,
    ISBN:"6595811100701"
    }
]);

db.MEMBER.insertMany([
    {
        memberID: 2005,
        firstName: "Matt",
        lastName: "Cornett",
        email: "mattn@gmail.com",
        phoneNo: "082558567"
    },
    {
         memberID: 2027,
        firstName: "Sam",
        lastName: "Conrad",
        email: "connie99@gmail.com",
        phoneNo: "0721234567"
    }
]);

2.3. db.BOOK.find(
   { publicationYear: { $gt: 2026 } }
);
2.4db.BORROWEDBOOKS.aggregate([
    {$group: {
        _id:null, 
        totalRevenue:{$sum:"$fineAmount"}}}
]);
2.5 db.BORROWEDBOOKS.deleteOne(
    {fineAmount:50}
);
2.6 
db.BORROWEDBOOKS.aggregate([
    {$lookup: {from:"MEMBER",
               localField: "memberID",
               foreignField: "memberID",
               as: "member"}},
{ $unwind: "$member"},
{
    $lookup: {from:"BOOK",
               localField: "ISBN",
               foreignField: "ISBN",
               as: "book"},
},
{ $unwind: "$book"},

{$project: {
        _id:0,
        memberID: "$member.memberID",
        firstName: "$member.firstName",
        lastName: "$member.lastName",
        title:"$book.title",
        dateBorrowed:1,
        dueDate:1,
        returnDate:1,
         fineAmount:1
}}    
])