SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 6 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 08 Nov 2017 My Price 6.00

Create and perform the following T-SQL statements:

Create and perform the following T-SQL statements:

 

  1. Write a T-SQL INSERT statement that will insert a new department called Research. Use the Week Three tab in the Sample Data Excel® spreadsheet for the data. Do not attempt to set the ID value, as it is automatically added. Once you have added this record by running the T-SQL statement, perform a SELECT statement on all records in the Departments table and note the ID of the new row you inserted.
  2. Write a T-SQL INSERT statement that will insert new employees for the Research department according to the data in the Week Three tab in the Sample Data Excel® spreadsheet. Do not attempt to set the ID value, as it is automatically added. Use the ID you noted in the previous T-SQL insert as the DepartmentID in the new employee records (these employees all are in the Research department. Once you have added these records by running the T-SQL statements, perform a select on all records in the Employees table.
  3. Update all employees in the Employees table and give each employee a 2.67% raise by creating a single T-SQL UPDATE statement to modify the data. Verify the data change by performing a SELECT statement that will show all rows and columns of the Employees table.
  4. Add another department to the Departments table using a T-SQL INSERT statement. Call this department 'Maintenance'. Show the results of this insert by selecting all rows and all columns from the Departments table.
  5. Remove the record you just added by creating and running a T-SQL DELETE statement that will delete the Maintenance department by using the ID of the Maintenance department.

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 08 Nov 2017 10:11 AM My Price 6.00

----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------Tha-----------nk -----------you----------- fo-----------r y-----------our----------- in-----------ter-----------est----------- an-----------d b-----------uyi-----------ng -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll -----------be -----------qui-----------ckl-----------y

Not Rated(0)