Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

USE THE MOVIES ON DVD DATABASE STRUCTURE TO ANSWER THE REMAINING QUESTIONS. Write the SQL statement that will create the MOVIE table enforcing constraints for

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
USE THE MOVIES ON DVD DATABASE STRUCTURE TO ANSWER THE REMAINING QUESTIONS. Write the SQL statement that will create the MOVIE table enforcing constraints for all primary and foreign keys as well as a check constraint on MPAA. Movies on DVD Database A A d = MovAct \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ Columm } & \multicolumn{1}{|c|}{DataType} & \multicolumn{1}{|c|}{ Length } & DecimalPlaces & \multicolumn{1}{|c|}{NullsAllowed?} & \multicolumn{1}{|c|}{ Description } \\ \hline MuNumb & Char & 4 & & No & Primary key (fk) \\ \hline ActNumb & Char & 4 & & No & Primary key (key) (fk) \\ \hline Salary & Decimal & 10 & 2 & Yes & Salarytheactorearnedforthismovie. \\ \hline Awards & Decimal & 2 & 0 & Numberofacademyawardstheactorwoinforthismov-ie. \\ \hline \end{tabular} Write the SQL statement that will add a column named DateBorn to the ACTOR table. Dateborn thould accept all legal dates. Write the SQL statement that will add an actor with an actor number of 500 and a name of Jane Doe to the Actor table. We are unsure of where Jane Doe lives at this time

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

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

Students also viewed these Databases questions

Question

Is the person willing to deal with the consequences?

Answered: 1 week ago