MKN1 — MKN1 TASK 2: NON-RELATIONAL
DATABASE DESIGN AND IMPLEMENTATION
DATA MANAGEMENT — D597
PRFA — MKN1
COMPETENCIES
4157.1.1 : Recommends an Appropriate Data Architecture
The learner recommends an appropriate data architecture.
4157.1.2 : Examines the Data Available for Analysis
The learner examines the data available for analysis to determine their dimension, quality,
relations, and limitations.
4157.1.4 : Implements Physical Data Models
The learner implements physical data models by incorporating required data.
4157.1.5 : Performs Queries to Answer a Business Question
The learner performs database queries to answer a business question.
4157.1.6 : Uses Appropriate Data Manipulation Language Statements
The learner uses appropriate data manipulation language statements to manage data.
INTRODUCTION
A common undertaking for a data analyst is to create databases using existing datasets. This
process involves the exploration of the source and target datasets to merge the data in a
meaningful and logical way.
You will replicate this common process as you complete this task. You will take external data
from either a document dataset or a graphical dataset and design a non-relational database
Preparation Task Overview Submissions Evaluation Report
6/30/25, 04:45
Page 1 of 11
solution. You will load the data into a database solution and retrieve or modify the data using
JSON datasets and MongoDB in the virtual lab environment.
Choose one of the scenarios provided in the Supporting Documents. Each scenario has
associated JSON files that will be located on the desktop of the WGU Virtual Lab environment.
You will complete the following:
1. Design a non-relational database solution.
2. Implement the solution.
3. Present the solution using Panopto to an audience that consists of your peers within a
project team.
Note: It is recommended to use the other scenario, different from the one you used in Task 1.
You will complete this performance assessment in the provided WGU Virtual Lab environment.
Your submission will be a design document that includes screenshots of your work in the lab
environment and a Panopto video.
REQUIREMENTS
Your submission must represent your original work and understanding of the course material.
Most performance assessment submissions are automatically scanned through the WGU
similarity checker. Students are strongly encouraged to wait for the similarity report to generate
after uploading their work and then review it to ensure Academic Authenticity guidelines are
met before submitting the file for evaluation. See Understanding Similarity Reports for more
information.
Grammarly Note:
Professional Communication will be automatically assessed through Grammarly for Education in
most performance assessments before a student submits work for evaluation. Students are
strongly encouraged to review the Grammarly for Education feedback prior to submitting work
for evaluation, as the overall submission will not pass without this aspect passing. See Use
Grammarly for Education Effectively for more information.
Microsoft Files Note:
Write your paper in Microsoft Word (.doc or .docx) unless another Microsoft product, or pdf, is
specified in the task directions. Tasks may not be submitted as cloud links, such as links to Google
Docs, Google Slides, OneDrive, etc. All supporting documentation, such as screenshots and
proof of experience, should be collected in a pdf file and submitted separately from the main
6/30/25, 04:45
Page 2 of 11
file. For more information, please see Computer System and Technology Requirements.
You must use the rubric to direct the creation of your submission because it provides detailed
criteria that will be used to evaluate your work. Each requirement below may be evaluated by
more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions
of the course.
Part 1: Design Document
A. Select one of the provided scenarios and complete the following:
1. Describe a business problem that can be solved with a database solution and is in
alignment with the chosen scenario.
2. Justify why a NoSQL database solution will solve the identified business problem.
3. Identify a NoSQL database type to solve the identified business problem.
4. Explain how the business data will be used within the database solution.
B. Discuss how the proposed database design addresses scalability concerns, including
strategies that align with the chosen scenario.
C. Outline the privacy and security measures that should be implemented in the proposed
database design.
Part 2: Implementation
Note: The data files for each scenario are located in a folder titled “D597 Datasets” on the
desktop of the WGU Virtual Lab environment. Be sure to pull the files from “Task 2” that relate
to your chosen scenario.
Note: Submit your screenshots from the WGU Virtual Lab for each prompt with your design
document.
D. Implement the proposed database design in the WGU Virtual Lab environment by completing
the following:
1. Write script to create a database instance named “D597 Task 2” using the appropriate
query language, based on your design in Part 1. Provide a screenshot showing the script
and the database instance in the platform.
2. Write script to insert or map the data records from the chosen scenario JSON files into the
6/30/25, 04:45
Page 3 of 11
database instance. Provide a screenshot showing the script and the data correctly
inserted or mapped into the database.
3. Write script for three queries to retrieve specific information from the database that will
help to solve the identified business problem. Provide a screenshot showing the script for
each query and each query successfully executed.
4. Apply optimization techniques to improve the run time of your queries from part D3,
providing output results via a screenshot.
Part 3: Presentation
Note: The audiovisual recording should feature you visibly presenting the material (i.e., not in
voiceover or embedded video) and should simultaneously capture both you and your multimedia
presentation.
Note: For instructions on how to access and use Panopto, use the “Panopto How-To Videos” web
link provided below. To access Panopto’s website, navigate to the web link titled “Panopto
Access” and then choose to log in using the “WGU” option. If prompted, log in using your WGU
student portal credentials, and then it will forward you to Panopto’s website.
To submit your recording, upload it to the Panopto drop box titled “Task 2: Non-Relational
Database Design and Implementation – MKN1 | D597.” Once the recording has been uploaded
and processed in Panopto’s system, retrieve the URL of the recording from Panopto and copy
and paste it into the Links option. Upload the remaining task requirements using the
Attachments option.
E. Present your functional database solution in the lab environment by doing the following:
1. Record a walk-through of your program appropriate for an audience of a project team
with technical knowledge using Panopto. Record yourself describing your program. Your
recording should capture both you and your functioning program. Your presentation
should also demonstrate appropriate communication skills for your audience, including a
professional appearance.
2. Demonstrate the following in your recorded walk-through:
• Discuss how database design and indexing strategy optimize performance.
• Describe the technical environment used in your database implementation.
• Demonstrate the functionality of the script in the lab environment.
• Discuss how the script solves the identified business problem.
F. Acknowledge sources, using in-text citations and references, for content that is quoted,
6/30/25, 04:45
Page 4 of 11
paraphrased, or summarized.
G. Demonstrate professional communication in the content and presentation of your
submission.
File Restrictions
File name may contain only letters, numbers, spaces, and these symbols: ! – _ . * ‘ ( )
File size limit: 200 MB
File types allowed: doc, docx, rtf, xls, xlsx, ppt, pptx, odt, pdf, csv, txt, qt, mov, mpg, avi, mp3, wav, mp4,
wma, flv, asf, mpeg, wmv, m4v, svg, tif, tiff, jpeg, jpg, gif, png, zip, rar, tar, 7z
RUBRIC
A1:BUSINESS PROBLEM
A2:DATABASE JUSTIFICATION
NOT EVIDENT
The submission does not
describe a business problem
that can be solved with a
database solution.
APPROACHING COMPE-
TENCE
The submission describes a
business problem that can
be solved with a database
solution, but the business
problem is not appropriate
for the chosen scenario or is
not in alignment with the
scenario.
COMPETENT
The submission describes a
business problem that can be
solved with a database solu-
tion and is in alignment with
the chosen scenario. The
business problem is appro-
priate for the scenario.
NOT EVIDENT
A justification is not provid-
ed.
APPROACHING COMPE-
TENCE
The submission does not
address why the NoSQL
database solution will solve
the identified business
problem, or the justification
is illogical or is not in align-
ment with the identified
COMPETENT
The submission logically jus-
tifies why a NoSQL database
solution will solve the identi-
fied business problem.
6/30/25, 04:45
Page 5 of 11
A3:DATABASE TYPE
A4:DATA USAGE
B:SCALABILITY
business problem.
NOT EVIDENT
A NoSQL database type is
not identified.
APPROACHING COMPE-
TENCE
The submission identifies a
NoSQL database type, but
the identified NoSQL data-
base type is not appropriate
for the identified business
problem.
COMPETENT
The submission identifies an
appropriate NoSQL database
type to solve the identified
business problem.
NOT EVIDENT
The submission does not
explain how the business
data will be used.
APPROACHING COMPE-
TENCE
The submission explains
how the business data will
be used within the database
solution, but the explana-
tion contains inaccuracies
or is not in alignment with
the scenario.
COMPETENT
The submission accurately
explains how the business
data will be used within the
database solution.
NOT EVIDENT
A discussion of how the pro-
posed database design ad-
dresses scalability concerns
is not provided.
APPROACHING COMPE-
TENCE
The submission discusses
how the proposed database
design addresses scalability
concerns but does not in-
clude strategies that align
with the chosen scenario, or
the discussion is incomplete.
COMPETENT
The submission discusses
how the proposed database
design addresses scalability
concerns and includes strate-
gies that align with the cho-
sen scenario.
6/30/25, 04:45
Page 6 of 11
C:PRIVACY AND SECURITY
D1:DATABASE INSTANCE
D2:INSERT RECORDS
NOT EVIDENT
An outline of the privacy
and security measures that
should be implemented is
not provided.
APPROACHING COMPE-
TENCE
The submission outlines the
privacy and security mea-
sures that should be imple-
mented in the proposed
database design, but the
measures provided contain
inaccuracies or are not in
alignment with the pro-
posed database design.
COMPETENT
The submission accurately
outlines the privacy and se-
curity measures that should
be implemented in the pro-
posed database design.
NOT EVIDENT
A script to create a database
instance is not provided.
APPROACHING COMPE-
TENCE
The script to create a data-
base instance using query
language is functional, but
the script is not based on
the logical data model creat-
ed in part B, or the query
language used is not appro-
priate. A screenshot show-
ing the script or of the data-
base instance created in the
platform is not provided.
COMPETENT
The script to create a data-
base instance using the ap-
propriate query language is
functional and is based on
the logical database model
created in part B. A clear
screenshot showing the
script and the database in-
stance in the platform is pro-
vided.
NOT EVIDENT
A script to insert or map the
data records is not provided
or is not functional.
APPROACHING COMPE-
TENCE
The script of a statement to
insert or map the data
records from the chosen
COMPETENT
The script provided to insert
or map the data records from
the chosen scenario JSON
6/30/25, 04:45
Page 7 of 11
D3:QUERIES
D4:OPTIMIZATION
scenario JSON files into the
database is functional, but
the submission does not
provide a screenshot show-
ing the script or the data
correctly inserted into the
database.
files into the database is
functional. A clear screen-
shot showing the script and
the data correctly inserted
or mapped into the database
is provided.
NOT EVIDENT
Scripts of 3 or fewer queries
to retrieve specific informa-
tion from the database are
not functional or not provid-
ed.
APPROACHING COMPE-
TENCE
The scripts provided for 3
queries to retrieve specific
information from the data-
base are functional, but one
or more of the queries will
not help solve the identified
business problem or the
submission does not provide
a screenshot showing the
script for each query suc-
cessfully executed.
COMPETENT
The scripts provided for 3
queries to retrieve specific
information from the data-
base that will help to solve
the identified business prob-
lem are functional. A clear
screenshot showing the
script for each query suc-
cessfully executed are pro-
vided.
NOT EVIDENT
The submission does not
provide a screenshot of the
output results demonstrat-
ing the optimization tech-
niques to improve the run
time of the queries.
APPROACHING COMPE-
TENCE
The submission applies opti-
mization techniques to im-
prove the run time of some
but not all of the queries
written in part D3, or the
optimization techniques do
not improve the run time, or
the submission does not
provide the output results
COMPETENT
The submission applies opti-
mization techniques to im-
prove the run time of each
the queries written in part
D3 and provides the output
results via a screenshot.
6/30/25, 04:45
Page 8 of 11
E1:PRESENTATION: ORGANIZATION AND PROFESSIONALISM
E2:PRESENTATION: CONTENT
F:SOURCES
via a screenshot.
NOT EVIDENT
A presentation is not sub-
mitted, or the video does
not capture both the pre-
senter and the functioning
program for the duration of
the presentation.
APPROACHING COMPE-
TENCE
The presentation of pro-
gram walk-through is un-
clear, is disorganized, or
does not demonstrate ap-
propriate communication
skills. Or the presenter’s ap-
pearance is unprofessional.
Or the presentation does
not include technical detail
or is inappropriate for an
audience of a project team
with technical knowledge.
COMPETENT
The presentation of the pro-
gram walk-through is clear, is
organized, and demonstrates
appropriate communication
skills. For the duration of the
presentation, the video cap-
tures both the presenter and
the functioning program in a
Panopto video recording.
The presenter’s appearance
is professional. The presen-
tation includes technical de-
tail appropriate for an audi-
ence of a project team with
technical knowledge.
NOT EVIDENT
A presentation depicting
the program is not submit-
ted, or the presentation
does not reflect a function-
ing program.
APPROACHING COMPE-
TENCE
The presentation does not
demonstrate each of the
given requirements, or 1 or
more of the requirements
are incomplete, or the infor-
mation provided contains
errors.
COMPETENT
The presentation thoroughly
and accurately demonstrates
each of the given require-
ments and reflects a func-
tioning database solution.
NOT EVIDENT APPROACHING COMPE- COMPETENT
6/30/25, 04:45
Page 9 of 11
G:PROFESSIONAL COMMUNICATION
WEB LINKS
Panopto Access
Sign in using the “WGU” option. If prompted, log in with your WGU student portal credentials,
which should forward you to Panopto’s website. If you have any problems accessing Panopto,
please contact Assessment Services at [email protected]. It may take up to two
business days to receive your WGU Panopto recording permissions once you have begun the
course.
The submission does not
include both in-text cita-
tions and a reference list for
sources that are quoted,
paraphrased, or summa-
rized.
TENCE
The submission includes in-
text citations for sources
that are quoted, para-
phrased, or summarized and
a reference list; however,
the citations or reference
list is incomplete or inaccu-
rate.
The submission includes in-
text citations for sources
that are properly quoted,
paraphrased, or summarized
and a reference list that ac-
curately identifies the au-
thor, date, title, and source
location as available, or the
submission states no sources
were used.
NOT EVIDENT
This submission includes
pervasive errors in profes-
sional communication relat-
ed to grammar, sentence
fluency, contextual spelling,
or punctuation, negatively
impacting the professional
quality and clarity of the
writing. Specific errors have
been identified by Gram-
marly for Education under
the Correctness category.
APPROACHING COMPE-
TENCE
This submission includes
substantial errors in profes-
sional communication relat-
ed to grammar, sentence
fluency, contextual spelling,
or punctuation. Specific er-
rors have been identified by
Grammarly for Education
under the Correctness cate-
gory.
COMPETENT
This submission includes sat-
isfactory use of grammar,
sentence fluency, contextual
spelling, and punctuation,
which promote accurate in-
terpretation and under-
standing.
6/30/25, 04:45
Page 10 of 11
Panopto FAQs
Panopto How-To Videos
WGU Virtual Lab Environment
SUPPORTING DOCUMENTS
Task 2 Scenario 1.zip
Task 2 Scenario 2.zip
6/30/25, 04:45
Page 11 of 11
