SQL 2005

Use SQL Management Studio to create a database called ITD640_P1.MDF. Add
the tables and data shown below to the database. Use the appropriate
field types and lengths for the tables.



Create the following queries and save them all in a file called
ITD640_P1.SQL. Define what database to use with a USE statement.

Get the full details of the employee table.

Get the full details of the employees who work in store S2.

Get the full details of the promotions with a budget greater than
$100,000.

Get the employee number and promotion number for employees with unknown
(NULL) jobs who work on promotion P2.

Using a subquery, get the first and last names of the employees who work
in the Orange Appeal store.

Using a subquery, get full details of all the employees whose stores are
located in Orlando.

Detach the database and create a zip file including the associated log
file and the query file. After creating the zip file, reattach the
database.

What I need is the following files:

1) SQL query script file containing all the queries described in
description.

2) A Word document containing screenshots for each query's execution, in
SQL Server 2005 Express Management Studio.

3) .mdf and .ldf files (data and log respectively) for the database
created.