How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Scott Your Own Question
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

I'd like to view an already answered question.

Customer Question

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 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.


Submitted: 2 years ago.
Category: Homework
Expert:  Ingo U replied 2 years ago.
Hi,what version of SQL are you using here?
Expert:  Ingo U replied 2 years ago.
Also, do you have any file that contains the table data in some kind of text format (i.e. not images) so I could speed up the importing/populating of the tables through a script? I.e. I wouldn't have to type every word by hand.
Customer: replied 2 years ago.

I am no longer in need of assistance on this topic

Expert:  Ingo U replied 2 years ago.
Thanks for letting me know.