CREATE DATABASE Movies

CREATE TABLE Directors (
Id INT PRIMARY KEY IDENTITY,
DirectorName VARCHAR(50) NOT NULL,
Notes VARCHAR(200)
)

INSERT INTO Directors
VALUES
('Gosho', 'Mnogo e lud'),
('Pesho', 'Mnogo se bie'),
('Aleksei', 'Mnogo e nagyl'),
('Sveti Petka', 'Mnogo'),
('Ksenia', 'Mnogo e visoka')



CREATE TABLE Genres (
Id INT PRIMARY KEY IDENTITY,
GenreName VARCHAR(50) NOT NULL,
Notes VARCHAR(200)
)

INSERT INTO Genres
VALUES
('Horror', 'Mnogo e lud'),
('Sci-Fi', 'Mnogo se bie'),
('Comedy', 'Mnogo e nagyl'),
('Drama', 'Mnogo'),
('Mistery', 'Mnogo e sexy')

CREATE TABLE Categories  (
Id INT PRIMARY KEY IDENTITY,
CategoryName VARCHAR(50) NOT NULL,
Notes VARCHAR(200)
)

INSERT INTO Categories
VALUES
('1', 'Mnogo e lud'),
('2', 'Mnogo se bie'),
('3', 'Mnogo e nagyl'),
('4', 'Mnogo'),
('5', 'Mnogo e sexy')

CREATE TABLE Movies (
Id INT PRIMARY KEY IDENTITY,
Title VARCHAR(50) NOT NULL,
DirectorId INT FOREIGN KEY REFERENCES Directors(Id),
CopyrightYear INT NOT NULL,
[Length] TIME,
GenreId INT FOREIGN KEY REFERENCES Genres(Id),
CategoryId INT FOREIGN KEY REFERENCES Categories(Id),
Rating INT CONSTRAINT Raiting_Check CHECK (Rating > 0 AND Rating <= 10),
Notes VARCHAR(200)

)

INSERT INTO  Movies
VALUES
('Vesdesyshtiq', 2, 2009, '01:02:01', 5, 4, 7, NULL),
('Zabranena lubov', 1, 2003, '00:37:01', 1, 4, 6, NULL),
('ASD', 1, 2001, '03:37:01', 1, 4, 6, NULL),
('DSA', 1, 1999, '00:37:01', 2, 4, 10, NULL),
('lubov', 5, 2019, '00:37:01', 1, 4, 9, 'Mnogo romantichen')