db.createCollection("authors");
db.createCollection("books");
db.createCollection("bookauthor");
db.createCollection("members");
db.createCollection("borrowedbooks");

show collections
db.authors.insertMany([
  { authorID: "au01", firstName: "Adewale", lastName: "Obaro" },
  { authorID: "au02", firstName: "Mia",     lastName: "Adrian" },
  { authorID: "au03", firstName: "Ntombi",  lastName: "Lebo" }
]);
db.books.insertMany([
  { ISBN: 50001, title: "Database Systems",               publicationYear: 2022, availability: "In Store", quantityInStock: 5 },
  { ISBN: 50002, title: "Introduction to Python Programming", publicationYear: 2026, availability: "Online",   quantityInStock: 3 },
  { ISBN: 50003, title: "Technical Programming",           publicationYear: 2027, availability: "In Store", quantityInStock: 4 }
]);
db.bookauthor.insertMany([
  { ISBN: 50001, authorID: "au01" },
  { ISBN: 50002, authorID: "au02" },
  { ISBN: 50003, authorID: "au03" }
]);
db.members.insertMany([
  { memberID: "MEM001", firstName: "Duma",   lastName: "Baloyi", email: "duma@gmail.com",   phoneNo: "0623456789" },
  { memberID: "MEM002", firstName: "Lerato", lastName: "Tebogo", email: "lerato@yahoo.com",  phoneNo: "0787654321" },
  { memberID: "MEM003", firstName: "Ndlovu", lastName: "Lesedi", email: "lesedi@gmail.com",  phoneNo: "0652820028" }
]);
db.borrowedbooks.insertMany([
  { memberID: "MEM001", ISBN: 50002, dateBorrowed: "2024-09-15", dueDate: "2024-10-25", returnDate: null,          fineAmount: 0 },
  { memberID: "MEM002", ISBN: 50003, dateBorrowed: "2024-04-15", dueDate: "2024-06-25", returnDate: "2024-09-25",  fineAmount: 50 },
  { memberID: "MEM003", ISBN: 50001, dateBorrowed: "2024-09-15", dueDate: "2024-11-25", returnDate: null,          fineAmount: 0 }
]);
db.authors.find();
db.books.find();
db.bookauthor.find();
db.members.find();
db.borrowedbooks.find();