use ITDSA_Project
db.createCollection("AUTHOR")
db.createCollection("BOOK")
db.createCollection("BOOKAUTHOR")
db.createCollection("MEMBER")
db.createCollection("BORROWEDBOOKS")
db.AUTHOR.insertMany([
{
    authorID: 1,
    firstName: "George",
    lastName: "Orwell"
},
{
    authorID: 2,
    firstName: "J.K.",
    lastName: "Rowling"
}
])
db.BOOK.insertMany([
{
    ISBN: "9780451524935",
    title: "1984",
    publicationYear: 2025
},
{
    ISBN: "9780747532743",
    title: "Harry Potter and the Philosopher's Stone",
    publicationYear: 2027
}
])