task_2.sql

-- Create the Authors table
CREATE TABLE IF NOT EXISTS Authors (
    author_id INT PRIMARY KEY AUTO_INCREMENT,
    author_name VARCHAR(215) NOT NULL
);


-- Create the book table
CREATE TABLE IF NOT EXISTS Books (
    book_id INT PRIMARY KEY AUTO_INCREMENT,
    title VARCHAR(130) NOT NULL,
    price DOUBLE NOT NULL,
    publication_date DATE,
    FOREIGN KEY (author_id) REFERENCES Authors(author_id)
);


-- Create Customers table
CREATE TABLE IF NOT EXISTS Customers (
    customer_id INT PRIMARY KEY AUTO_INCREMENT,
    customer_name VARCHAR(215) NOT NULL,
    email VARCHAR(215) UNIQUE,
    address TEXT
);



-- Create the Orders table
CREATE TABLE IF NOT EXISTS Orders (
   order_id INT PRIMARY KEY AUTO_INCREMENT
   order_date DATE
   FOREIGN KEY (customer_id) REFERENCES Customers(customer_id)
);


-- Create the orderdetail table
CRAETE TABLE IF NOT EXISTS Order_Details (
    orderdetail_id INT PRIMARY KEY AUTO_INCREMENT,
    quantity DOUBLE,
    FOREIGN KEY (book_id) REFERENCES Books(book_id)
    FOREIGN KEY (order_id) REFERENCES Orders(order_id)
);