SQL Query

CREATE TABLE Books (
    ISBN CHAR(13),
    Title VARCHAR(70) NOT NULL,
    Quantity INT NOT NULL CHECK(Quantity>=0),
    Price DECIMAL(9,2) NOT NULL,
    Author INT NOT NULL,
    CONSTRAINT PK_Books PRIMARY KEY (ISBN)
    -- constraint FK_Books_Authors foreign key (author) references Authors(ID)
);

CREATE TABLE Authors(
   AuthorID INT AUTO_INCREMENT,
   Name VARCHAR(70) NOT NULL,
   Age INT NOT NULL CHECK(age>=10 & age<=130),
   Experience INT ,
   CONSTRAINT PK_Authors PRIMARY KEY (AuthorID)
);

CREATE TABLE Orders(
    ID INT AUTO_INCREMENT,
    Quantity INT NOT NULL,
    Price DECIMAL(9,2),
    Book CHAR(13),
    CONSTRAINT PK_Orders PRIMARY KEY (ID),
    CONSTRAINT FK_Orders_Book FOREIGN KEY (Book) REFERENCES Books(ISBN)
);

CREATE TABLE Authors_Books (
    BookISBN CHAR(13),
    AuthorID INT,
    CONSTRAINT PK_Authors_Books PRIMARY KEY (BookISBN, AuthorID),
    CONSTRAINT FK_Authors_Books_Books FOREIGN KEY (BookISBN) REFERENCES Books(ISBN),
    CONSTRAINT FK_Authors_Books_Authors FOREIGN KEY (AuthorID) REFERENCES Authors(AuthorID)
);