Using Oracle SQL Developer

Create a simple Movie database based on below model. You should have 9 tables in total in your Database. The table columns are given on the left side and their respective data type is given on the right.

The code I have:

create table Movie( mov_id integer primary key, mov_title char(50), mov_year integer, mov_time integer, mov_lang char(50), mov_dt_rel date, mov_rel_country char(5));

create table genres( gen_id integer primary key, gen_title char(20));

create table movie_genres( mov_id integer, gen_id integer , primary key (mov_id,gen_id), foreign key(mov_id) references movie(mov_id), foreign key(gen_id) references genres(gen_id));

create table Reviewer( rev_id integer primary key, rev_name char(30));

create table rating( mov_id integer, rev_id integer , rev_stars integer, num_o_ratings integer, primary key (mov_id,rev_id), foreign key(mov_id) references movie(mov_id), foreign key(rev_id) references Reviewer(rev_id));

create table director( dir_id integer primary key, dir_fname char(20), dir_lname char(20));

create table movie_direction( dir_id integer , mov_id integer, primary key (mov_id,dir_id), foreign key(mov_id) references movie(mov_id), foreign key(dir_id) references director(dir_id));

create table actor( act_id integer primary key, act_fname char(20), act_lname char(20), act_gender char(1));

create table movie_cast( act_id integer , mov_id integer, role char(30), primary key (mov_id,act_id), foreign key(mov_id) references movie(mov_id), foreign key(act_id) references actor(act_id));

The error I get:

Error starting at line : 69 in command - create table Movie( mov_id integer primary key, mov_title char(50), mov_year integer, mov_time integer, mov_lang char(50), mov_dt_rel date, mov_rel_country char(5)) Error report - ORA-00955: name is already used by an existing object 00955. 00000 - "name is already used by an existing object" *Cause: *Action:

Table GENRES created.

Table MOVIE_GENRES created.

Table REVIEWER created.

Table RATING created.

Table DIRECTOR created.

Table MOVIE_DIRECTION created.

Error starting at line : 121 in command - create table actor( act_id integer primary key, act_fname char(20), act_lname char(20), act_gender char(1)) Error report - ORA-00955: name is already used by an existing object 00955. 00000 - "name is already used by an existing object" *Cause: *Action:

Error starting at line : 128 in command - create table movie_cast( act_id integer , mov_id integer, role char(30), primary key (mov_id,act_id), foreign key(mov_id) references movie(mov_id), foreign key(act_id) references actor(act_id)) Error report - ORA-00955: name is already used by an existing object 00955. 00000 - "name is already used by an existing object" *Cause: *Action: