You will use the script provided and execute the script in your own folder in Win Labs SQL Server. The txt file is located in the folder for Lab #7. You will need to copy/paste the resulting displays from the execution of the script into a document that you will submit for this lab.

You will insert data into 2nd set of 7 tables. These are the tables that you wrote the SQL to create the 2nd set of 7 tables in Lab #6. The values that you will insert are provided below. Some data fields are not provided. Please create the necessary values for data that has not been provided. Note: you will need to create the data in the background tables so that foreign key constraints will be satisfied. In this part, you will be updating data to correct some errors. Note that the update may not be a single simple command but rather a series of commands if a field identified as a primary key needs modified. You will copy/paste the commands you execute along with the messages displayed from the execution of all your commands. Write the SQL code to fix the following "errors":