DROP TABLE if exists movie; 
/* Delete table if it already exists */

CREATE TABLE movie ( 
	title varchar(30), 
	year int, 
	length int, 
	in_color int, 
	studio varchar(20), 
	producer_cert varchar(3),
	primary key (title, year)
 );


 
DROP TABLE if exists star; 
/* Delete table if it already exists */


CREATE TABLE star(
        name varchar(30),
        address varchar(30),
        gender char(1),
        birthdate char(20)
);


DROP TABLE if exists starsin; 
/* Delete table if it already exists */ 

CREATE TABLE starsin 
(
 	movie_title varchar(30), 
	movie_year int, 
	star_name varchar(30) 
);


DROP TABLE if exists movieexec; 
/* Delete table if it already exists */
create table movieexec(
        name varchar(30),
        address char(30), 
        cert int primary key, 
        net_worth int
);

DROP TABLE if exists studio;

create table studio(
 	 name varchar(30) primary key,
     president_cert int
);