Insert, Update, Delete
Problems
1-5 Insert the following new customer, his vehicle, and the services provided. He is not going to become a registered customer at this time. (This will require multiple insert statements. You will also need to look up the automatically generate keys to use as foreign keys.)
Jay Russell, license BFM349, Ford Fusion, 2011, at the new Tacoma shop. He got an oil change and new windshield wipers.
6. Registered customer 7 has a new email address. Change it to "laura26@yahoo.com" change the password to "moonshine"
7. Change the price of auto service 12 to $110.90
8. Delete AutoserviceDetailID 80 from vehicle service detail.
What I am Looking for
The insert requires some effort. Not only do you have to do multiple insert statements, you also have to look up vales, and the inserts must be done in the correct order. 1through 5 are wort 7 points. The others are worth 1 point each, though they are not without their dangers
To Turn In
Copy the SQL code to a Google doc and share it with spconger@gmail.com
No comments:
Post a Comment