CREATE TABLE MOVIE (
 movie_id SERIAL PRIMARY KEY,
 title VARCHAR(255) NOT NULL,
 category VARCHAR(255) NOT NULL,
 price_category VARCHAR(255) NOT NULL
);

CREATE TABLE VIDEO (
 video_id SERIAL PRIMARY KEY,
 movie_id INTEGER REFERENCES MOVIE(movie_id) NOT NULL
);

CREATE TABLE MEMBERSHIP (
 member_id SERIAL PRIMARY KEY,
 first_name VARCHAR(255) NOT NULL,
 last_name VARCHAR(255) NOT NULL,
 email VARCHAR(255) UNIQUE NOT NULL
);

CREATE TABLE RENTAL (
 rental_id SERIAL PRIMARY KEY,
 rental_date DATE NOT NULL,
 price DECIMAL(10,2),
 member_id INTEGER REFERENCES MEMBERSHIP(member_id) NOT NULL
);

CREATE TABLE DETAILRENTAL (
 rental_id INTEGER REFERENCES RENTAL(rental_id) NOT NULL,
 video_id INTEGER REFERENCES VIDEO(video_id) NOT NULL,
 PRIMARY KEY (rental_id, video_id)
);