Chapter 11, Problem 17QY

In the formula below, which references will update when copied? =$C$3+$E7 a. Row 3 b. Row 7 c. Column C d. Column E

2.7 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: Add a Producer column with VARCHAR data type (max 50 chars). Remove the Genre column. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.

You will be using the Colonial Adventure Tours database. List the trip IDs and trip names for each pair of trips that have the same start location.(You will need to assign an alias). The first trip id should be the major sort key, and the second trip id  should be the minor sort key.