TheodoreJohnson_CBT NUGGETS LAB 16_CIS376

docx

School

Strayer University, Tampa *

*We aren’t endorsed by this school

Course

376

Subject

Information Systems

Date

Dec 6, 2023

Type

docx

Pages

Uploaded by DeanChinchillaPerson22

LAB 16: Writing Queries that Modify Data Theodore Johnson SU200641522 Screenshot 1: Using AdventureWorks examine the columns in the table Department in the HumanResources schema. Add five new rows into the table for all columns that are not null. Examine the data and pick five DepartmentID values that will unique to meet primary key concerns. Take a screen shot of the SQL windows and results and paste it here. Screenshot 2: Select the data from the table for the data inserted into Part 1 Take a screen shot of the SQL windows and results and paste it here.

Screenshot 3: Change the GroupName for each of the five rows added in part 1. Take a screen shot of the SQL windows and results and paste it here. Screenshot 4: Select the data from the table for the data inserted into Part 1 Take a screen shot of the SQL windows and results and paste it here.

Screenshot 5: Delete all the rows that were created from Part 1 of the lab. Select the data from the table for the data inserted into Part 1. Take a screen shot of the SQL windows and results and paste it here.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

TheodoreJohnson_CBT NUGGETS LAB 16_CIS376

Related Documents