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

db.AUTHOR.insertMany([
  {authorID: "au01", firstName: "Adewale", lastName: "Obaro"}, 
  {authorID: "au02", firstName: "Mia", lastName: "Adrian"}
]);

db.BOOK.insertMany([
  {ISBN: 50001, title: "Database Systems", publicationYear: 2022}, 
  {ISBN: 50002, title: "Introduction to Python", publicationYear: 2027}
]);

db.MEMBER.insertMany([
  {memberID: "MEM001", firstName: "Duma", lastName: "Baloyi"}, 
  {memberID: "MEM002", firstName: "Lerato", lastName: "Tebogo"}
]);

db.BOOKAUTHOR.insertMany([
  {authorID: "au01", ISBN: 50001}, 
  {authorID: "au02", ISBN: 50002}
]);

db.BORROWEDBOOKS.insertMany([
  {memberID: "MEM001", ISBN: 50002, dateBorrowed: "2026-09-15", dueDate: "2026-10-15", returnDate: null, fineAmount: 10}, 
  {memberID: "MEM002", ISBN: 50001, dateBorrowed: "2026-04-15", dueDate: "2026-05-15", returnDate: "2026-05-20", fineAmount: 50}
]);