Transact-SQL Project

During this project, you are going to be creating your own database from a script and then run Transact-SQL queries against that database.

You will also end up with possibly several files to submit. Just gather them in one directory and zip them up for submission.

Step One

Atached to the assignment you will find a .sql file. This is a special file for SQL databases. The file contains script commands to create and populate a database.

Task

Open the database within SSMS. Examine the contents of the script. There are some statements in the script we have not covered yet, but hopefully (fingersed crossed), are self-explanatory.

Once you have looked through the script, you will open a Word document. Within the Word document, I want you to select one of each of the following statement types listed below, copy it into that word document and then describe what the statement does.

• "IF NOT EXISTS"
• "SELECT...FROM...WHERE"
• "DROP"
• "CREATE"
• "PRIMARY KEY"
• "CONSTRAINT"
• "FOREIGN KEY"
• "EXECUTE"

Step Two

Create Database

Follow the directions at the top of the .sql file to alter the code for db creation. Replace the db with the word, "RedwoodLastname", where "Lastname" is your last name.

The path is D:\Redwood\. Note: include the trailing slash. This is the directory that contains the .csv files to populate the db.

Take a screenshot of the creation to submit.

Step Three

I would like you to write Transact-SQL statements that contain the following...

Aggregate

• AVG
• MAX
• MIN
• SUM
• COUNT

String

• Concat
• Left
• Len
• Substring
• Replace
• Right

Date

• DATEDIFF
• DATEPART

Take a screenshot of the creation to submit.