The Movie table has the following columns: ID - integer, primary...

The Movie table has the following columns:

• ID - integer, primary key
• Title - variable-length string
• Genre - variable-length string
• RatingCode - variable-length string
• Year - integer

Write ALTER statements to make the following modifications to the Movie table:

1. Add a Producer column with VARCHAR data type (max 50 chars).
2. Remove the Genre column.
3. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT

Answer rating: 100% (QA)

You can use ALTER statements to make the specified modifications to the Movie ... View the full answer