db.createCollection("author")
db.createCollection("bookauthor")
db.createCollection("book")
db.createCollection("borrowedbooks")
db.createCollection("member")

show collections

db.author.insertMany([
  { authorID: "A001", firstName: "Chinua", lastName: "Achebe" },
  { authorID: "A002", firstName: "Trevor", lastName: "Noah" }
])

db.book.insertMany([
  { ISBN: "9780385474542", title: "Things Fall Apart", publicationYear: 1958, availability: "in store", quantityInStock: 5 },
  { ISBN: "9780399588174", title: "Born a Crime", publicationYear: 2016, availability: "online", quantityInStock: 8 }
])

db.bookauthor.insertMany([
  { ISBN: "9780385474542", authorID: "A001" },
  { ISBN: "9780399588174", authorID: "A002" }
])

db.member.insertMany([
  { memberID: "M001", firstName: "Lindiwe", lastName: "Zulu", email: "lindiwe@gmail.com", phoneNo: "0821234567" },
  { memberID: "M002", firstName: "James", lastName: "van der Merwe" }
])

db.borrowedbooks.insertMany([
  { memberID: "M001", ISBN: "9780385474542", dateBorrowed: new Date("2026-06-01"), dueDate: new Date("2026-06-15"), returnDate: null, fineAmount: 0 },
  { memberID: "M002", ISBN: "9780399588174", dateBorrowed: new Date("2026-06-10"), dueDate: new Date("2026-06-24"), returnDate: null, fineAmount: 0 }
])


db.author.find()
db.book.find()
db.bookauthor.find()
db.member.find()
db.borrowedbooks.find()