SQL EXERCISE

EDITING DATA

1) Use insert statements to add the following records to each table BELOW. You'll need to find the identity value created for new records in tables on the one-side of relationships (for example, Operator ID #1 in the entries for Runs refers to the first operator in the list, not a particular identity value). (8 points)

After completing the above entries:

2.In the Trips table, change Capital Mall to Westfield Shopping Mall using an Update command for all trips with an effective date after 10/1/04. (4 points)

3.Change the model year for all phantoms to 1994 using an Update command. (4 points)

4.Delete the 9/1/04 9:15am departure from Yelm using a Delete command. (4 points)

5.Delete operator 4. Don't forget referential integrity, but do not delete any trips or vehicles. (5 points)

Operators Hire Date 1/1/01 1/10/01 2/15/02 6/15/02 8/19/03 5/5/04 Seniority First Name David Tony Shirley John Tanya Peter Last Name Letterman Bennet Temple Adams Tucker Parker 4 6