SQL Assignment

CREATE TABLE account_logins (
       account_id int,
       account_name varchar(255),
       account_password varchar(255),
       account_email varchar(255),
       account_other_info varchar(255),
       PRIMARY KEY (account_id)
       );

CREATE TABLE seat_price (
       cinema_id int,
       standard_seat_price decimal,
       vip_seat_price decimal,
       virtual_seat_price decimal,
       senior_price decimal,
       adult_price decimal,
       child_price decimal,
       discount_applied decimal,
       month varchar(255),
       movie varchar(255),
       PRIMARY KEY (cinema_id)
       );

CREATE TABLE movie_seat_booking (
       booking_id int,
       account_id int,
       booking_seat_row varchar(255),
       booking_seat_number int,
       movie_id int,
       cinema_screen int,
       PRIMARY KEY (booking_id)
       );

CREATE TABLE movies (
       movie_id int,
       movie_name varchar(255),
       movie_month varchar(255),
       movie_year varchar(255),
       movie_time decimal,
       movie_screen int,
       movie_genre varchar(255),
       movie_rating decimal,
       cinema_name varchar(255),
       PRIMARY KEY (movie_id)
       );

CREATE TABLE cinemas (
       cinema_id int,
       cinema_name varchar(255),
       cinema_screens int,
       cinema_screen_seat_capacity int,
       PRIMARY KEY (cinema_id)
       );