---

CREATE DATABASE DB_Books;
GO

USE DB_Books;
GO


USE DB_Books;

CREATE TABLE Authors (
    AuthorID INT PRIMARY KEY,
    NameAuthor VARCHAR(50),
    Country VARCHAR(30)
);

CREATE TABLE Publishing_House (
    Code_publish INT PRIMARY KEY,
    Name_publish VARCHAR(50),
    City VARCHAR(30)
);

CREATE TABLE Books (
    BookID INT PRIMARY KEY,
    Title VARCHAR(50),
    AuthorID INT,
    Code_publish INT,
    Price INT,
    FOREIGN KEY (AuthorID) REFERENCES Authors(AuthorID),
    FOREIGN KEY (Code_publish) REFERENCES Publishing_House(Code_publish)
);

CREATE TABLE Sales (
    SaleID INT PRIMARY KEY,
    BookID INT,
    Quantity INT,
    SaleDate DATE,
    FOREIGN KEY (BookID) REFERENCES Books(BookID)
);

INSERT INTO Authors VALUES
(1, 'Pushkin', 'Russia'),
(2, 'Tolstoy', 'Russia'),
(3, 'Rowling', 'UK');

INSERT INTO Publishing_House VALUES
(1, 'AST', 'Moscow'),
(2, 'Eksmo', 'Moscow'),
(3, 'Bloomsbury', 'London');

INSERT INTO Books VALUES
(1, 'Eugene Onegin', 1, 1, 500),
(2, 'War and Peace', 2, 2, 700),
(3, 'Harry Potter', 3, 3, 900);

INSERT INTO Sales VALUES
(1, 1, 5, '2025-01-10'),
(2, 2, 3, '2025-02-15'),
(3, 3, 8, '2025-03-20');