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