// Insert into AUTHOR
db.AUTHOR.insertMany([
    { authorID: "A01", firstName: "George", lastName: "Orwell" },
    { authorID: "A02", firstName: "Jane", lastName: "Austen" }
]);

// Insert into BOOK 
// (Note: Included one book published after 2026 to support Question 2.3)
db.BOOK.insertMany([
    { ISBN: "978-1-0001", title: "1984", publicationYear: 1949 },
    { ISBN: "978-2-0002", title: "Future Tech Innovations", publicationYear: 2027 }
]);

// Insert into BOOKAUTHOR (Bridge Collection)
db.BOOKAUTHOR.insertMany([
    { authorID: "A01", ISBN: "978-1-0001" },
    { authorID: "A02", ISBN: "978-2-0002" }
]);

// Insert into MEMBER
db.MEMBER.insertMany([
    { memberID: "M01", firstName: "Alice", lastName: "Smith", email: "alice@eduvos.com", phoneNo: "0821234567" },
    { memberID: "M02", firstName: "Bob", lastName: "Jones", email: "bob@eduvos.com", phoneNo: "0837654321" }
]);

// Insert into BORROWEDBOOKS (Bridge Collection)
// (Note: Included one record with a fine of 50 to support Question 2.5)
db.BORROWEDBOOKS.insertMany([
    { memberID: "M01", ISBN: "978-1-0001", dateBorrowed: new Date("2026-05-01"), dueDate: new Date("2026-05-15"), returnDate: new Date("2026-05-20"), fineAmount: 50 },
    { memberID: "M02", ISBN: "978-2-0002", dateBorrowed: new Date("2026-06-10"), dueDate: new Date("2026-06-24"), returnDate: null, fineAmount: 0 }
]);