database and query file zipped

Stuck with a difficult assignment? No time to get your paper done? Feeling confused? If you’re looking for reliable and timely help for assignments, you’ve come to the right place. We promise 100% original, plagiarism-free papers custom-written for you. Yes, we write every assignment from scratch and it’s solely custom-made for you.


Order a Similar Paper Order a Different Paper

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data 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.

Please submit your assignment.

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data 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.

Please submit your assignment.


Writerbay.net

We’ve proficient writers who can handle both short and long papers, be they academic or non-academic papers, on topics ranging from soup to nuts (both literally and as the saying goes, if you know what we mean). We know how much you care about your grades and academic success. That's why we ensure the highest quality for your assignment. We're ready to help you even in the most critical situation. We're the perfect solution for all your writing needs.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper