Question: CREATE TABLE Movie ( ID INT PRIMARY KEY CHECK ( ID < = 5 0 0 0 0 ) , Title VARCHAR ( 5 0

CREATE TABLE Movie ( ID INT PRIMARY KEY CHECK (ID <=50000), Title VARCHAR(50), Rating CHAR(4), ReleaseDate DATE, Budget DECIMAL(8,2) CHECK (Budget <=999999.99)); 2.13 LAB - Create Movie table Create a Movie table with the following columns: - ID - positive integer with maximum value of 50,000- Title - variable-length string with up to 50 characters - Rating - fixed-length string with 4 characters - ReleaseDate - date - Budget - decimal value representing a cost of up to 999,999 dollars, with 2 digits for cents Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.Expected result 2:Test Title column Your result 3:Test Rating column Your result 4:Test ReleaseDate column Your result 5:Test Budget column

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!