Hello, can you please assist with the following problem? Q1. Using the DBMS 130 Course Project ERD and Table Details spreadsheet, develop and run an APEX script to CREATE the 6 tables and all the constraints (PK, FK, NOT NULL, etc.). Q2. Add these two constraints to the FLIX_MOVIES table 1. Movie Rating can only have these values: a. G b. PG c. PG13 d. PG-13 e. R 2. Movie Category can only have these values a. DRAMA b. COMEDY c. ACTION d. SCIFI e. CHILD f. DOCUMENTARY Q3. Add a UNIQUE constraint to the Email column of FLIX_CUSTOMERS. Place comments in your script including course number, date, your name, and other relevant comments. In APEX, name your script: Course_Project_Part_1_yourInitials.sql NOTE: Each script name must be unique in APEX. That is why you must use your initials in the name of your script. Otherwise, you will receive an APEX error.
Hello, can you please assist with the following problem?
Q1.
Using the DBMS 130 Course Project ERD and Table Details spreadsheet, develop and
run an APEX script to CREATE the 6 tables and all the constraints (PK, FK, NOT NULL,
etc.).
Q2.
Add these two constraints to the FLIX_MOVIES table
1. Movie Rating can only have these values:
a. G
b. PG
c. PG13
d. PG-13
e. R
2. Movie Category can only have these values
a. DRAMA
b. COMEDY
c. ACTION
d. SCIFI
e. CHILD
f. DOCUMENTARY
Q3.
Add a UNIQUE constraint to the Email column of FLIX_CUSTOMERS.
Place comments in your script including course number, date, your name, and other
relevant comments.
In APEX, name your script:
Course_Project_Part_1_yourInitials.sql
NOTE: Each script name must be unique in APEX. That is why you must
use your initials in the name of your script. Otherwise, you will receive an
APEX error.
Step by step
Solved in 3 steps