TheMovietable has the following columns:

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

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

1. Add aProducercolumn with VARCHAR data type (max 50 chars).
2. Remove theGenrecolumn.
3. Change the Year column's name toReleaseYear, and change the data type toSMALLINT.