Use SQL Server to complete the following queries.

Find your assigned virtual machine.

Download the document, Accessing your Virtual Machine. Follow the directions.

Review the Using SQL Server PowerPoint.

Download the TAL.sql and the Sports.sql documents onto your virtual machine.

Open the SQL Server Management Studio.

Copy and Paste the TAL.sql code into the SQL Server Management Studio Query window and execute the query. The directions are in the Using SQL Server PowerPoint.

Do the same for the Sports.sql code.

Open a new query window and create the following queries.

1. Create a table named Sports_Therapist. The table should have the same structure as the Therapist table. Use the Sports Database.
2. Use the sp_columns in a query to display the Sports_Therapist column definitions.
3. Insert the following data into the Sports_Therapist table:

(TW309, Ida, Dunno, 101 Lovely Lane, Palm Rivers, TX, 75213).

4. Create an INSERT INTO query to insert that data from the Therapist table.
5. UPDATE the street address for Therapist number BM273 to 4966 Dolby Lane.
6. Delete the record where the TherapistID is TW309.
7. Rename the ZipCode field name to PostalCode.
8. Remove the Sports_Therapist table from the database.

Save all queries in one file and name it Assigment3.sql

Submit the Assignment3.sql in the Module 3 Assignment box.

Theparist table:

CREATE TABLE Therapist ( TherapistID CHAR(5) PRIMARY KEY, LastName VARCHAR(25), FirstName VARCHAR(25), Street VARCHAR(30), City CHAR(35), State CHAR(2), ZipCode CHAR(5) );