Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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.

image text in transcribedimage text in transcribed

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 DB

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions