Question
hello i know you dont use APEX but could you help me creating the tables? DBMS 130: Course Project Description 120 points 1 Course Project
hello i know you dont use APEX but could you help me creating the tables?
DBMS 130: Course Project Description 120 points 1 Course Project Part 1 20 points Using the DBMS 130 Course Project ERD and Table Details spreadsheet, develop an APEX script to CREATE the 6 tables and all the constraints (PK, FK, NOT NULL, etc.). Add these two constraints to the FLIX_MOVIES table 1. Movie Rating can only have these values: a. G b. PG c. PG13 or PG-13 d. R 2. Movie Category can only have these values a. DRAMA b. COMEDY c. ACTION d. SCIFI e. DOCUMENTARY 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. In IVY Learn there will be a text box for Submission. When your script is ready, simple type my script is ready for grading in the text box and click Submit. I will grade your script directly in APEX.
DBMS 130: Course Project ERD \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ FLIX_CUSTOMERS } \\ \hline PK & Customer_ID \\ \hline & Last_Name \\ & First_Name \\ Home_Phone \\ Cell_Phone \\ Email \\ Street1 \\ Street2 \\ City \\ State_Province \\ Postal_Code \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ FLIX_RENTAL_HISTORY } \\ \hline PK & Rental_Histor_ID \\ \hline FK & Customer_ID \\ FK & Media_ID \\ & Rental_Date \\ & Return_Date \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ FLIX_ACTORS } \\ \hline PK & Actor_ID \\ \hline & Stage_Name \\ & Last_Name \\ & First_Name \\ & Birth_Date \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ FLIX_STAR_BILLING } \\ \hline PK & Star_Billing_ID \\ \hline FK & Actor_ID \\ FK & Tite_ID \\ & Comments \\ \hline \end{tabular} DBMS 130: Course Project DBStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started