// AUTHOR collection
db.AUTHOR.insertMany([
  { authorID: 1, firstName: "John", lastName: "Doe" },
  { authorID: 2, firstName: "Jane", lastName: "Smith" }
]);

// BOOKAUTHOR collection
db.BOOKAUTHOR.insertMany([
  { ISBN: "978-3-16-148410-0", authorID: 1 },
  { ISBN: "978-1-40-289462-6", authorID: 2 }
]);

// BOOK collection
db.BOOK.insertMany([
  { ISBN: "978-3-16-148410-0", title: "MongoDB for Beginners", publicationYear: 2027, format: "online", quantityInStock: 10 },
  { ISBN: "978-1-40-289462-6", title: "Advanced Databases", publicationYear: 2025, format: "store", quantityInStock: 5 }
]);

// MEMBER collection
db.MEMBER.insertMany([
  { memberID: 101, firstName: "Alice", lastName: "Johnson", email: "alice.j@example.com", phoneNo: "123-4567890" },
  { memberID: 102, firstName: "Bob", lastName: "Williams" }  // Email and phoneNo optional
]);

// BORROWEDBOOKS collection
db.BORROWEDBOOKS.insertMany([
  { memberID: 101, ISBN: "978-3-16-148410-0", dateBorrowed: ISODate("2027-01-15"), dueDate: ISODate("2027-02-15"), returnDate: null, fineAmount: 0 },
  { memberID: 102, ISBN: "978-1-40-289462-6", dateBorrowed: ISODate("2027-03-01"), dueDate: ISODate("2027-03-31"), returnDate: ISODate("2027-04-05"), fineAmount: 50 }
]);