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:

C++ Programming: From Problem Analysis to Program Design
8th Edition
ISBN:9781337102087
Author:D. S. Malik
Publisher:D. S. Malik
Chapter9: Records (struct)
Section: Chapter Questions
Problem 16SA
icon
Related questions
Question
5.10 LAB - Alter Movie table
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.
387248.2524230.gx3zay7
LAB
ACTIVITY
5.10.1: LAB - Alter Movie table
Main.sql
Transcribed Image Text:5.10 LAB - Alter Movie table 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. 387248.2524230.gx3zay7 LAB ACTIVITY 5.10.1: LAB - Alter Movie table Main.sql
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
C-string
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning