Question: how come these two codes doesnt have a outcome Create a Movie table with the following columns: - ID - positive integer with maximum value

how come these two codes doesnt have a outcome
how come these two codes doesnt have a outcome Create a Movie
table with the following columns: - ID - positive integer with maximum

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. Main.sql CREATE TABLE Movie C ID INTEGER NOT NULL PRIMARY KEY, Title VARCHAR(50) NOT NULL, Rating CHAR (4) NOT NULL, ReleaseDate DATE NOT NULL, Budget DECIMAL (7,2) NOT NULL )i Write ALTER statements to make the following modifications to the Movie table: 1. Add a Producer column with VARCHAR data type ( max50 chars). 2. Remove the Genre column: 3. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT. Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code

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!