Posted: February 26th, 2023

SYM WK3

XML/JSON Explanation

Assessment Description

View the “JSON Basics” video within the “Video Playlist: Relational Databases for Business Applications,” located in the topic Resources.

In a single Microsoft Word document, answer each prompt below with its own 200- to 250-word paragraph (four paragraphs total).

1. Explain the basic concepts of JavaScript Object Notation (JSON).

2. Explain what makes an eXtensible markup language (XML) document different from a text file.

3. Discuss factors that should be considered when deciding whether or not it is worth indexing an XML column in a SQL Server database.

4. Discuss the pros and cons of storing XML data in a SQL Server database as opposed to storing the XML as documents in a file system.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

Rubric Criteria

Expand All Rubric CriteriaExpand All

Basic Concepts of JavaScript Object Notation (JSON)

13.65 points

eXtensible Markup Language (XML) Document vs. a Text File

13.65 points

Factors When Deciding Whether to Index an XML Column in a SQL Server DB

13.65 points

Pros and Cons of Storing XML Data in a SQL Server DB vs. Documents in a File System

13.65 points

Mechanics of Writing

3.9 points

Word Count/Length

2.6 points

Documentation of Sources

XML Basics Application

The purpose of this assignment is to explain XML concepts and the appropriate use of XML.

The IT department is rolling out a new product application for the marketing department and has requested your expertise in addressing some questions related to an upcoming project: IT is exploring inputting data from SQL Server through XML.

Start the VM, and inside the VM, click Start, type SSMS (to open SQL Server Management Studio), and connect to the instance. Select Databases, then right-click on the AdventureWorks2017 database and select New Query.

Execute the following steps:

1. Select * from Person.Person Where FirstName = ‘John’ For XML path. Take a screenshot of the Select statement and the result window.

2. Click on the XML link in the results area to open the XML view.

3. Right-click on the SSMS query tab above the view and save the file as “xmlTest.xml.” Take a screenshot of the file.

4. Construct a SQL transaction to import the “xmlTest.xml” results file back into SQL Server. 
Hint: Use the Commands OPENROWSET and OPENXML and the two stored procedures “sp_xml_preparedocument” and “sp_xml_removedocument”. Take a screenshot of your SQL transaction code and its result. (Result should be a display of all “John” values in Person.Person.)

Submit the following in a single document compatible with the digital classroom (e.g., Microsoft Word). Include a one-line description above each screenshot.

· Screenshot(s) of Select statement and result window (#1)

· Screenshot of the xmlTest file (#3)

· Screenshot of SQL transaction code from SMSS and results of executing transaction code (#4)

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

Rubric Criteria

Expand All Rubric CriteriaExpand All

Select Statement and Result Window Screenshot and One-Line Description

19.5 points

xmlTest File Screenshot and One-Line Description

13 points

SQL Transaction Code and Results Screenshot and One-Line Description