Explore BrainMass

Using SQL Management Studio to Create a Database.

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

Please refer to the attached document for data.

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 ITCO630_P1.SQL. Please note that you can execute individual queries in a query file by highlighting the lines that you want to execute before running the script. 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 called ITCO630_P1.ZIP including the associated log file and the query file. After creating the zip file, reattach the database

© BrainMass Inc. brainmass.com September 24, 2018, 10:20 am ad1c9bdddf - https://brainmass.com/business/management-information-systems/using-sql-management-studio-to-create-a-database-500721


Solution Summary

The ITCO630_P1.zip file contains complete solution to stated problem.