Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

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

More Books

Students also viewed these Databases questions

Question

draft a research report or dissertation;

Answered: 1 week ago