(You are to put all your screen snapshots for the items below, each showing the required SQL statements and results, in order, in a single Microsoft Word file. Failure to do so may result in lost points on this assignment.)
Using the fully populated Employee and Job_Title tables and data from Week Three, write queries using SQL UPDATE and DELETE statements. (2-1/2 points each)
Note: As a precaution, you should SELECT all of the data from both of your tables before you perform the following updates (i.e. UPDATE and DELETE statements) as a check that you’ll be affecting the correct data! But it’s the UPDATE and DELETE statements that actually change the data that you’ll be graded on. You don’t need to show the results of your “quick check” SELECT, but be sure to include all the SQL and SQL Server responses for your UPDATEs and DELETEs.