Answered step by step
Verified Expert Solution
Link Copied!

Question

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 to Expert-Tailored 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

Recommended Textbook for

Datacasting How To Stream Databases Over The Internet

Authors: Jessica Keyes

1st Edition

007034678X, 978-0070346789

More Books

Students also viewed these Databases questions

Question

Acceptance of the key role of people in this process of adaptation.

Answered: 1 week ago

Question

preference for well defined job functions;

Answered: 1 week ago