db.createCollection("AUTHOR");
db.createCollection("BOOK");
db.createCollection("MEMBER");
db.createCollection("BOOKAUTHOR");
db.createCollection("BORROWEDBOOKS");
db.AUTHOR.insertMany([
  { authorID: 1, firstName: "Adewale", lastName: "Ogunleye" },
  { authorID: 2, firstName: "Lindiwe", lastName: "Mthembu" }
]);
db.BOOK.insertMany([
  { ISBN: "978-0143127741", title: "Data Modeling Essentials", publicationYear: 2025, availability: "store", quantityInStock: 5 },
  { ISBN: "978-0262033848", title: "Graph Databases Explained", publicationYear: 2027, availability: "online", quantityInStock: 999 }
]);
db.BOOKAUTHOR.insertMany([
  { ISBN: "978-0143127741", authorID: 1 },
  { ISBN: "978-0262033848", authorID: 2 },
  { ISBN: "978-0262033848", authorID: 1 } 
]);
db.MEMBER.insertMany([
  { memberID: 1001, firstName: "Thabo", lastName: "Dlamini", email: "thabo.d@example.com", phoneNo: "0712345678" },
  { memberID: 1002, firstName: "Ayanda", lastName: "Khumalo" } // no email/phone provided
]);
db.BORROWEDBOOKS.insertMany([
  {
    memberID: 1001,
    ISBN: "978-0143127741",
    dateBorrowed: ISODate("2026-11-15T00:00:00Z"),
    dueDate: ISODate("2026-12-15T00:00:00Z"),
    returnDate: ISODate("2026-12-10T00:00:00Z"),
    fineAmount: 0
  },
  {
    memberID: 1002,
    ISBN: "978-0262033848",
    dateBorrowed: ISODate("2027-02-01T00:00:00Z"),
    dueDate: ISODate("2027-03-01T00:00:00Z"),
    returnDate: null,
    fineAmount: 0
  }
]);
db.BOOK.find({ publicationYear: { $gt: 2026 } }).pretty();