Question: oracle sql hw help! SQL Tables In SQL Developer, create the following tables. Table: Movies Column_name Data_type Constraint movie_id number(8) primary key movie_name varchar2(30) not

oracle sql hw help!
oracle sql hw help! SQL Tables In SQL Developer, create the following
tables. Table: Movies Column_name Data_type Constraint movie_id number(8) primary key movie_name varchar2(30)

SQL Tables In SQL Developer, create the following tables. Table: Movies Column_name Data_type Constraint movie_id number(8) primary key movie_name varchar2(30) not mill movie_budget number(10,2) movie_budget > 0 gross_sales number(10,2) gross_sales >= 0 Paste the SQL for creating this table below: Table: People Column_name Data_type Constraint person_id number(8) primary key person_name varchar2(30) not null person_type varchar2(10) only 'Director' or 'Actor salary number(10,2) salary > 0 Paste the SQL for creating this table below: Table: Movie_People Column_name Data_type movie_id number(8) person_id mumber(8) Constraint foreign key (movie_id) foreign key (person_id) Paste the SQL for creating this table below: Updating the movie_people table Add a primary key constraint for the movie_people table. The primary key is (movie_id, person_id). Paste the SQLs for doing this below

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!