Program 3 (Create and Insert)

Creation of Tables

CREATE TABLE ACTOR(Act_id int PRIMARY KEY, Act_name varchar(20),Act_gender char);

CREATE TABLE DIRECTOR(Dir_id int PRIMARY KEY, Dir_name varchar(20), Dir_phn int);

CREATE TABLE MOVIES(Mov_id int PRIMARY KEY,Mov_title varchar(30), Mov_year int, Mov_lang varchar(10), Dir_id int REFERENCES DIRECTOR(dir_id));

CREATE TABLE MOVIE_CAST(Act_id int REFERENCES ACTOR(act_id),Mov_id int REFERENCES MOVIES(mov_id), Role varchar(15),PRIMARY KEY(Act_id,Mov_id));

CREATE TABLE RATING(Mov_id int PRIMARY KEY, Rev_stars int,FOREIGN KEY(Mov_id)REFERENCES MOVIES(mov_id));

Insertion of rows to the table

INSERT INTO ACTOR VALUES('&Act_id', '&Act_Name', '&Act_Gender');

INSERT INTO DIRECTOR VALUES('&Dir_id','& Dir_Name','&Dir_Phone');

INSERT INTO MOVIES VALUES('&Mov_id', '&Mov_Title','&Mov_Year','&Mov_Lang', '&Dir_id');

INSERT INTO MOVIE_CAST VALUES('&Act_id', '&Mov_id','&Role');

INSERT INTO RATING VALUES('&Mov_id', '&Rev_Stars');