Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started