TheodoreJohnson_CBT NUGGETS LAB 24&25_CIS376
docx
keyboard_arrow_up
School
Strayer University, Tampa *
*We aren’t endorsed by this school
Course
376
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
6
Uploaded by DeanChinchillaPerson22
LAB 24: Writing Queries against Temporal Data
Theodore Johnson
SU200641522
Screenshot 1:
Using WideWorldImporters and the Warehouse schema add the following values to the Colors
table for the columns ColorName and LastEditedBy: Dark Gray, 1; Scarlet, 1; Light Gray, 1;
Almond, 1; Nyanza, 1. Take a screen shot of the SQL windows and results and paste it here.
Screenshot 2:
Write a query to select all rows from the table Colors that were added in Part 1. Take a screen
shot of the SQL windows and results and paste it here.
Screenshot 3:
Write a query to select all rows from the temporal table for Colors. Take a screen shot of the
SQL windows and results and paste it here.
Screenshot 4:
Change the values of LastEditedBy for the rows added in Part 1 to a 9. Take a screen shot of the
SQL windows and results and paste it here
Screenshot 5:
Write a query to select all rows from the temporal table for Colors. 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
LAB 25: Writing Queries against XML and JSON Data
Theodore Johnson
SU200641522
Screenshot 1:
Using the WideWorldImporters database and the Warehouse schema write a query that returns
the result set transformed to XML data. The query will return StockItemID, StockItemName,
Brand, Size, TaxRate, UnitPrice, ValidFrom and ValidTo from the table StockItems. The XML file
will have the following structure: root name will be InventoryInfo, the path name will be
Product. StockItemId will be an attribute of the path name. StockItemName and UnitPrice will
be elements of the path name. Brand and Size will be attributes of an element named
Descriptioin in the path name. TaxRate will be an attribute of an element named TaxInfo in the
path name. ValidFrom and ValidTo will be child elements of an element named ValidDates in the
path name. Take a screen shot of the SQL windows and results and paste it here.
Screenshot 2:
Double click on the resulting XML column from the above query to fully display the XML
structure. Take a screen shot of the SQL windows and results and paste it here.
Screenshot 3:
Using the WideWorldImporters database and the Warehouse schema write a query that returns
the result set transformed to JSON data. The query will return StockItemID, StockItemName,
Brand, Size, TaxRate, UnitPrice, ValidFrom and ValidTo from the table StockItems. Take a screen
shot of the SQL windows and results and paste it here.
Screenshot 4:
Using the WideWorldImporters database and the Warehouse schema write a query that returns
the StockItemName, Brand, Size, and CountryOfManufacture from the JSON column
CustomFields from the table StockItems. Only return rows where the CountryOfManufacture is
not USA..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