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
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
