CREATE TABLE Movies (
MovieID INT NOT NULL PRIMARY KEY,
Name VARCHAR(50) NOT NULL,
GenreID INT NOT NULL REFERENCES Genres(GenreID),
DirectorID INT NOT NULL REFERENCES Directors(DirectorID),
Duration INT NOT NULL,
)

CREATE TABLE Directors(
DirectorID INT NOT NULL PRIMARY KEY,
Name VARCHAR(50) NOT NULL,
Age INT NOT NULL,
Born DATE NOT NULL,
Nationality VARCHAR(50) NOT NULL,
)


CREATE TABLE Movies_actors(
MovieID INT NOT NULL REFERENCES Movies(MovieID),
ActorID INT NOT NULL REFERENCES Actors(ActorID)
)

CREATE TABLE Actors(
ActorID INT NOT NULL PRIMARY KEY,
Name VARCHAR(50) NOT NULL,
Age INT NOT NULL,
Born DATE NOT NULL,
Nationality VARCHAR(50) NOT NULL,
)


CREATE TABLE Genres (
GenreID INT NOT NULL PRIMARY KEY,
Genre VARCHAR(50) NOT NULL,
)



INSERT INTO Genres (GenreID, Genre) VALUES
(1, 'Comedy'),
(2, 'Action'),
(3, 'Horror'),
(4, 'Crime'),
(5, 'Fantasy'),
(6, 'History'),
(7, 'Romance'),
(8, 'War'),
(9, 'Music'),
(10, 'Documentary');

CREATE TABLE Customer(
CustomerID INT NOT NULL PRIMARY KEY,
FirstName VARCHAR(50) NOT NULL,
LastName VARCHAR(50) NOT NULL,
Adress VARCHAR(50) NOT NULL,
City VARCHAR(50) NOT NULL,
Country VARCHAR(50) NOT NULL)

INSERT INTO Customer(CustomerID, FirstName, LastName, Adress, City,Country) VALUES
('1', 'Ivan', 'Todorov', 'Rakovski 6', 'Sofia', 'Bulgaria'),
('2', 'Sergei', 'Jovovich', 'Cheskaq 22', 'Sofia', 'Bulgaria'),
('3', 'Rosica', 'Miteva', 'Cherni vruh 22', 'Sofia', 'Bulgaria');



CREATE TABLE Rent (
OrderID INT NOT NULL PRIMARY KEY,
DATE DATE NOT NULL,
CustomerID INT NOT NULL REFERENCES Customer (CustomerID),
MovieID INT NOT NULL REFERENCES Movies(MovieID))