USE master

CREATE DATABASE Movies

CREATE TABLE Directors
(Id int NOT NULL PRIMARY KEY IDENTITY,
DirectorName nvarchar(50) NOT NULL,
Notes nvarchar(255))

INSERT INTO Directors (DirectorName)
VALUES ('Stiven Spilberg')

INSERT INTO Directors (DirectorName)
VALUES ('Хачо Бояджиев')

INSERT INTO Directors (DirectorName)
VALUES ('James Cameron')

INSERT INTO Directors (DirectorName)
VALUES ('Robert Zemeckis')

INSERT INTO Directors (DirectorName)
VALUES ('Peter Jackson')

CREATE TABLE Genres
(Id int NOT NULL PRIMARY KEY IDENTITY,
GenreName nvarchar(50) NOT NULL,
Notes nvarchar(255))

INSERT INTO Genres(GenreName)
VALUES ('Comedy')

INSERT INTO Genres(GenreName)
VALUES ('Horror')

INSERT INTO Genres(GenreName)
VALUES ('Action')

INSERT INTO Genres(GenreName)
VALUES ('Crime')

INSERT INTO Genres(GenreName)
VALUES ('Adventure')

CREATE TABLE Categories
(Id int NOT NULL PRIMARY KEY IDENTITY,
CategoryName nvarchar(50) NOT NULL,
Notes nvarchar(255))

INSERT INTO Categories(CategoryName)
VALUES ('Popular')

INSERT INTO Categories(CategoryName)
VALUES ('Bollywood')

INSERT INTO Categories(CategoryName)
VALUES ('Cartoon')

INSERT INTO Categories(CategoryName)
VALUES ('Hollywood')

INSERT INTO Categories(CategoryName)
VALUES ('another')

-- Movies (Id, Title, DirectorId, CopyrightYear, Length, GenreId, CategoryId, Rating, Notes)

CREATE TABLE Movies
(Id int NOT NULL PRIMARY KEY IDENTITY,
Title nvarchar(50) NOT NULL,
DirectorId int NOT NULL,
CopyrightYear int,
Length int,
GenreId int NOT NULL,
CategoryId int NOT NULL,
Rating int,
Notes nvarchar(255))

INSERT INTO Movies (Title, DirectorId, GenreId, CategoryId)
VALUES ('Terminator', 3, 3, 4)

INSERT INTO Movies (Title, DirectorId, GenreId, CategoryId)
VALUES ('Indiana Jones and the Last Crusade', 1, 3, 4)

INSERT INTO Movies (Title, DirectorId, GenreId, CategoryId)
VALUES ('Some film', 5, 5, 5)

INSERT INTO Movies (Title, DirectorId, GenreId, CategoryId)
VALUES ('Криворазбраната цивилизация', 2, 1, 5)

INSERT INTO Movies (Title, DirectorId, GenreId, CategoryId)
VALUES ('Another film', 1, 1, 5)