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),
       account_tickets_purchased int,
       PRIMARY KEY (account_id)
       );

CREATE TABLE seat_price (
       cinema_id int,
       standard_seat_ticket decimal,
       vip_seat_ticket decimal,
       virtual_seat_ticket decimal,
       senior_ticket decimal,
       adult_ticket decimal,
       child_ticket decimal,
       discount_applied decimal,
       standard_ticket_price decimal,
       vip_seat_ticket_price decimal,
       virtual_seat_ticket_price decimal,
       senior_ticket_price decimal,
       adult_ticket_price decimal,
       child_ticket_price decimal,
       discounted_ticket_price decimal,
       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_show_date varchar(255),
       movie_screen int,
       movie_genre varchar(255),
       movie_rating decimal,
       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)
       );