use("olms");

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

db.AUTHOR.insertMany([
  {
    authorID: 1,
    firstName: "George",
    lastName: "Orwell"
  },
  {
    authorID: 2,
    firstName: "Stephen",
    lastName: "King"
  }
]);

db.BOOK.insertMany([
  {
    ISBN: "09876543321",
    title: "IT",
    publicationYear: 1986
  },
  {
    ISBN: "0123456789",
    title: "",
    publicationYear: "King"
  }
]);