1 / 36100%
CIS515
Preview: CIS515 : Strategic Planning for Database Systems
Course Guide
Prerequisites
Course Description
Instructional Materials
CIS500 or CIS512
This course covers the concepts, issues, principles, and techniques for managing organizational
data resources. Topics include the strategic information requirements of organizations, modeling
those requirements using conceptual data modeling techniques, verifying the structural
characteristics with normalization, and converting the conceptual data models into physical
databases. Emphasis will be placed on the application and strategic use of database systems.
Required Resources
uCertify. No date. Data Design Specialist v1.1. Pearson uCertify Certified Academic Courses.
https://strayer.ucertify.com
Note: It is crucial that you purchase and activate uCertify and complete the required activities
and labs in order to succeed in this course. You must activate uCertify through the link in
Blackboard Week 1 (do not go directly to the uCertify website).
Jeang-Kuo Chen. 2019. An Introduction of NoSQL Databases Based on Their Categories and
Application Industries. https://doi.org/10.3390/a12050106
Stefanos Georgiou. 2019. Software Development Lifecycle for Energy Efficiency: Techniques and
Tools. https://doi.org/10.1145/3337773
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Course Learning Outcomes
Weekly Course Schedule
Week 1 - To Do List
uCertify: Read "Introduction to Databases."
uCertify: View the "Introduction to Databases" video.
L. Mokokwe. 2018. First Things First: Adopting a Holistic, Needs-Driven Approach to Improving the
Quality of Routinely Collected Data. https://doi.org/10.1200/jgo.18.68700
Yulia Shichkina. 2019. Approaches to Speed Up Data Processing in Relational Databases.
http://libdatab.strayer.edu/login?url=https://search.ebscohost.com/login.aspx?
direct=true&db=edo&AN=136347618&site=eds-live&scope=site
Supplemental Resources
Certification Partners. No date. CIW Database Design Specialist. https://www.ciwcertified.com/ciw-
certifications/web-development-series/database-design-specialist
Examine the concepts and constructs of relational databases.
1
Propose a database design.
2
Create a database using normalization techniques and logical/physical design
best practices.
3
Generate SQL statements to perform database functions.
4
Recommend strategies to minimize security risk and improve database
performance.
5
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Week 1 - To Do List
Discuss: Introduce yourself and complete the discussion, "Database Administrator's Role."
uCertify: Complete the "Introduction to Databases" quiz.
Week 2 - To Do List
uCertify: Read "Relational Database Fundamentals."
uCertify: View the "Relational Database Fundamentals" video.
Discuss: Complete the discussion, "The Entity Relationship Model."
uCertify: Complete the "Relational Database Fundamentals" quiz.
Week 3 - To Do List
uCertify: Read "Database Planning."
uCertify: View the "Database Planning" video.
Discuss: Complete the discussion, "Planning the DLBC."
uCertify: Complete the "Database Planning" quiz.
Prepare: Review the instructions for the assignment due in Week 4.
Week 4 - To Do List
uCertify: Read "Overview of Database Design Methodology."
uCertify: View the "Overview of Database Design Methodology" video.
Discuss: Complete the discussion, "Planning Database Design."
uCertify: Complete the "Overview of Database Design Methodology" quiz.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Week 4 - To Do List
Assignment: Submit the assignment, "University Database."
Prepare: Review the instructions for the assignment due in Week 5.
Week 5 - To Do List
uCertify: Read "Normalization."
uCertify: View the "Normalization" video.
Discuss: Complete the discussion, "Optimizing Database Design."
uCertify: Complete the "Normalization" quiz.
Assignment: Submit the assignment, "Database Modeling and Normalization."
Week 6 - To Do List
uCertify: Read "Logical Database Design."
uCertify: View the "Logical Database Design" video.
Discuss: Complete the discussion, "Logical and Physical Design."
uCertify: Complete the "Logical Database Design" quiz.
uCertify: View the activities, Practice Tests A, B, and C. You must take each of these at least once
by the end of the course. Your highest score on each test will count as a grade in the course.
Week 7 - To Do List
uCertify: Read "Physical Database Design."
uCertify: View the "Physical Database Design" video.
Discuss: Complete the discussion, "Denormalization Functionality."
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Week 7 - To Do List
uCertify: Complete the "Physical Database Design" quiz.
uCertify: Complete the assignment, "Virtual Lab."
Assignment: Submit the assignment, "Creating Base Relation for the ProAudio Database" lab.
Assignment: Submit the assignment, "Creating Relations and Adding CHECK Constraints" lab.
uCertify: View the activities, Practice Tests A, B, and C. You must take each of these at least once
by the end of the course. Your highest score on each test will count as a grade in the course.
Week 8 - To Do List
uCertify: Read "Structured Query Language."
uCertify: View the "Structured Query Language" video.
Discuss: Complete the discussion, "Advanced SQL and PL/SQL."
uCertify: Complete the "Structured Query Language" quiz.
uCertify: Complete the activity, "Virtual Lab."
Assignment: Submit the "Using the INSERT Statement" lab.
Assignment: Submit the "Using DDL" lab.
Assignment: Submit the "Deleting and Updating Records" lab.
Assignment: Submit the "Using the IN, BETWEEN, and LIKE Operators" lab.
Assignment: Submit the "Retrieving Records From a Database" lab.
uCertify: View the activities, Practice Tests A, B, and C. You must take each of these at least once
by the end of the course. Your highest score on each test will count as a grade in the course.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Week 9 - To Do ListWeek 9 - To Do List
uCertify: Read "Relational Algebra."
uCertify: View the "Relational Algebra" video.
Discuss: Complete the discussion, "Relational Set Operators."
uCertify: Complete the "Relational Algebra" quiz.
uCertify: Complete the "Joining Relations" Lab.
Assignment: Submit the assignment, "Joining Relations" lab.
Prepare: Review the instructions for the assignment due in Week 10.
uCertify: View the activities, Practice Tests A, B, and C. You must take each of these at least once
by the end of the course. Your highest score on each test will count as a grade in the course.
Week 10 - To Do List
uCertify: Read "Transactions and Database Security."
uCertify: View the "Transactions and Database Security" video.
Discuss: Complete the discussion, "Concurrency Control."
uCertify: Complete the "Transactions and Database Security" quiz.
Assignment: Submit the assignment, "Case Study."
uCertify: View the activities, Practice Tests A, B, and C. You must take each of these at least once
by the end of the course. Your highest score on each test will count as a grade in the course.
Week 11 - To Do List
Discuss: Complete the discussion, "Course Closure."
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Week 11 - To Do List
uCertify: View the activities, Practice Tests A, B, and C. You must take each of these at least once
by the end of the course. Your highest score on each test will count as a grade in the course.
uCertify: Practice Test A.
uCertify: Practice Test B.
uCertify: Practice Test C.
Grading Scale
Participation Total Points % of Grade
Discussion Participation 200 20%
Assignment Total Points % of Grade
Week 1 - Introduction to Databases Quiz 20 2%
Week 2 - Relational Database Fundamentals Quiz 20 2%
Week 3 - Database Planning Quiz 20 2%
Week 4 - Overview of Database Design
Methodology Quiz
20 2%
Week 4 Assignment - University Database 100 10%
Week 5 - Normalization Quiz 20 2%
Week 5 Assignment - Database Modeling and
Normalization
100 10%
Week 6 - Logical Database Design Quiz 20 2%
Week 6 - Practice Test A 20 2%
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Assignment Total Points % of Grade
Week 6 - Practice Test B 20 2%
Week 6 - Practice Test C 20 2%
Week 7 - Physical Database Design Quiz 20 2%
Week 7 Assignment 1 - Submit Creating Base
Relation for the ProAudio Database Lab
30 3%
Week 7 Assignment 2 - Submit Creating Relations
and Adding CHECK Constraints Lab
30 3%
Week 8 - Structured Query Language Quiz 20 2%
Week 8 Assignment 1 - Submit Using the INSERT
Statement Lab
30 3%
Week 8 Assignment 2 - Submit Using DDL Lab 30 3%
Week 8 Assignment 3 - Submit Deleting and
Updating Records Lab
30 3%
Week 8 Assignment 4 - Submit Using the IN,
BETWEEN, and LIKE Operators Lab
30 3%
Week 8 Assignment 5 - Submit Retrieving Records
From a Database Lab
30 3%
Week 9 - Relational Algebra Quiz 20 2%
Week 9 Assignment - Submit Joining Relations Lab 30 3%
Week 10 - Transactions and Database Security
Quiz
20 2%
Week 10 Assignment - Case Study 100 10%
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Assignment Total Points % of Grade
Totals 1000 100%
Final Course Grade
Points Percentage Grade
900 - 1000 90% - 100% A
800 - 899 80% - 89% B
700 - 799 70% - 79% C
0 - 699 69% and below F
Unique Course Features
Grading Scale Notation
Please consult the University Catalog and your academic advisor to determine the final grade needed
in this class to satisfy your specific degree conferral requirements.
Academic Integrity
Please be sure to review the entire Academic Integrity Policy in the Student Handbook before
submitting anything in this course. In order to enforce its Academic Integrity Policy, the University
reserves the right to review any work (draft or otherwise) or exam submitted by a student during his or
her entire academic career at Strayer.
uCertify Overview
uCertify provides quality test prep kits for global IT certifications, including certification practice
assessments, interactive course materials, as well as automated feedback designed to encourage
student achievement.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
The unlimited use of uCertify is encouraged throughout this course in preparation for certification
readiness. Students are encouraged to review their assessment results, including both correct and
incorrect questions, in order to understand the rationale behind each answer.
The use of uCertify is a required component of the course that includes both graded and non-graded
participation assessments.
uCertify Access and Registration
Students must purchase a uCertify access code from the Strayer Bookstore.
Students must register the uCertify product via the instructions and link provided in the
Blackboard online course shell.
Once registered, students may access the uCertify materials for up to 12 months via:
The uCertify tab, located in the Blackboard online course shell; or,
A web browser, at: http://strayer.ucertify.com/
Note: When manually accessing the materials via http://strayer.ucertify.com/, you may
retrieve/reset your password through the "Forgot password?" feature.
uCertify Help and Support
For technical questions or problems associated with accessing uCertify, please contact
uCertify support at http://www.ucertify.com/support.php
For problems associated with obtaining an access code, please contact the Strayer University
Online Bookstore by calling 855-561-7052 or submitting a ticket at www.strayerbookstore.com
or www.jwmibookstore.com on the "Contact Us" page.
uCertify: Access After Class is Over
Students may access the uCertify materials for up to twelve (12) months from the time of
registration. Example: A student who registers for this class in Fall 2018 will be able access the
materials through Summer 2019. Access is available via the uCertify tab, located in the
Blackboard online course shell, or via a Web browser, at: http://strayer.ucertify.com/. (If you
choose to access the materials manually via http://strayer.ucertify.com/, you may retrieve/reset
your password through the "Forgot password?" feature.)
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Assignments
Lab Participation and Attendance Policy
The uCertify lab is used to support your learning in this course. However, activities completed in
uCertify do not count for attendance. You are only given credit for attendance when you
complete one of the following tasks in Blackboard before 11:59 p.m. EST on Sunday: submit
a discussion post, complete a quiz or exam, or submit an assignment. Be sure to complete one
of these activities each week in Blackboard to be counted present.
Week 4 Assignment - University Database
Summary
Click the linked activity title to access this assignment.
Before you turn in your assignment, make sure that you:
Review the instructions.
Ask questions early and often!
Use feedback you have received on other assignments while working on this one.
Text
Overview
A prestigious university has recently implemented a consolidation strategy that will require it to
centralize their student records. In order to move forward, the local university will need to develop a
data model that will retain student records and perform various data extract transform and load
(ETL) processes. Imagine that you have been hired as a database consultant to assist in the
development of a data design strategy for the student records.
You met with various university subject matter experts and have determined the following after
performing various business analysis processes:
Faculty groups are divided by core competencies that the university offers. For example, there
are groups such as the art faculty, computer technology faculty, language faculty, and science
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
faculty. Each faculty member has an assigned dean and is designated to teach at one
particular campus and school. They are able to teach as many courses as required.
Courses are categorized by course code and title. Certain courses have prerequisites and the
university has asked for this to be cataloged as well.
There are various schools within each campus. For example, the Los Angeles campus holds
the following schools: School of Science, School of Law, and School of Computer Technology.
Additionally, each school offers different professional study programs, such as Forensic
Computer Science, Marine Biology, Business Management, and Civil Engineering, to name a
few.
The study path for students requires that they be enrolled in a specific professional study
program. The professional study program requires the students to complete a specific set of
core courses. The university also requires that an online grade book be available. The online
grade book should show grades awarded to students for specific courses and the term they
completed the course.
The university identifies each student by their name, date of birth, social, and professional
study program.
Instructions
Using these findings, write a 3–4 page paper in which you:
Analyze the university's requirements and provide a proposal to organize all the required data
elements. The proposal should include the following:
Provide an entity relationship model (ERM) that will describe the data structure that will
store all data elements. Note: The graphically depicted solution is not included in the
required page length.
Describe any assumptions or limitations for each relationship. For example, professors
are able to teach more than one course, or students can only be enrolled in one program.
Create the primary key and foreign keys using a UML class diagram for each table.
Suggest at least four types of business intelligence reports that could help the university in
course management, student enrollment, or historical tracking. Support your answer by
providing specific business functions that these reports could be used for to assist executives
of the university.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Consider outsourcing the functions above as an alternative for development of the database.
Research the Internet and other media sources for vendors who develop registrar and school
management database systems.
Suggest three vendors that developed and are employing efficient registrar and school
management database systems and support your reasons to choose from one of these
three vendors.
Compare and contrast the key aspects that each system offers. Examples of system
aspects include but are not limited to cloud based, pricing model, open source, et cetera.
Go to the Strayer Library to locate at least three quality resources in this assignment. Note:
Wikipedia and similar websites do not qualify as quality resources.
The cover page and the reference page are not included in the required assignment page
length. Include charts or diagrams created in any chart or drawing tool with which you are
familiar. The completed diagrams or charts must be imported into the Word document before
the paper is submitted.
This course requires the use of Strayer Writing Standards. For assistance and information, please
refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your
professor for any additional instructions.
The specific course learning outcome associated with this assignment is:
Propose a database design.
Scoring Guide
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Analyze the university's requirements and provide a proposal to organize all the required data
elements: Provide an entity relationship model (ERM) that will describe the data structure that will
store all data elements. 10 %
Unacceptable (Below
70%)
Did not submit or
incompletely analyzed
the university's
requirements and
provided a proposal to
organize all the
required data
elements: Provided
an ERM that will
describe the data
structure that will
store all data
elements.
Needs Improvement (70-
79%)
Partially analyzed the
university's
requirements and
provided a proposal to
organize all the
required data
elements: Provided
an ERM that will
describe the data
structure that will
store all data
elements.
Competent (80-89%)
Satisfactorily
analyzed the
university’s
requirements and
provided a proposal to
organize all the
required data
elements: Provided
an ERM that will
describe the data
structure that will
store all data
elements.
Exemplary (90-100%)
Thoroughly analyzed
the university’s
requirements and
provided a proposal to
organize all the
required data
elements: Provided
an ERM that will
describe the data
structure that will
store all data
elements.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Analyze the university's requirements and provide a proposal to organize all the required data
elements: Describe any assumptions or limitations for each relationship. For example, professors are
able to teach more than one course, or students can only be enrolled in one program. 10 %
Unacceptable (Below
70%)
Did not submit or
incompletely analyzed
the university's
requirements and
provided a proposal to
organize all the
required data
elements: Described
any assumptions or
limitations for each
relationship. For
example, professors
are able to teach
more than one
course, or students
can only be enrolled
in one program
Needs Improvement (70-
79%)
Partially analyzed the
university's
requirements and
provide a proposal to
organize all the
required data
elements: Described
any assumptions or
limitations for each
relationship. For
example, professors
are able to teach
more than one
course, or students
can only be enrolled
in one program.
Competent (80-89%)
Satisfactorily
analyzed the
university’s
requirements and
provide a proposal to
organize all the
required data
elements: Described
any assumptions or
limitations for each
relationship. For
example, professors
are able to teach
more than one
course, or students
can only be enrolled
in one program.
Exemplary (90-100%)
Thoroughly analyzed
the university’s
requirements and
provide a proposal to
organize all the
required data
elements: Described
any assumptions or
limitations for each
relationship. For
example, professors
are able to teach
more than one
course, or students
can only be enrolled
in one program.
Create the primary key and foreign keys using a UML class diagram for each table. 15 %
Unacceptable (Below
70%)
Did not submit or
incompletely created
the primary key and
foreign keys using a
UML class diagram
for each table.
Needs Improvement (70-
79%)
Partially created the
primary key and
foreign keys using a
UML class diagram
for each table.
Competent (80-89%)
Satisfactorily created
the primary key and
foreign keys using a
UML class diagram
for each table.
Exemplary (90-100%)
Thoroughly created
the primary key and
foreign keys using a
UML class diagram
for each table.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Suggest at least four types of business intelligence reports that could help the university in course
management, student enrollment, or historical tracking. Support your answer by providing specific
business functions that these reports could assist executives of the university. 20 %
Unacceptable (Below
70%)
Did not submit or
incompletely
suggested at least
four types of business
intelligence reports
that could help the
university in course
management, student
enrollment, or
historical tracking. Did
not support your
answer by providing
specific business
functions that these
reports could assist
executives of the
university.
Needs Improvement (70-
79%)
Partially suggested at
least four types of
business intelligence
reports that could help
the university in
course management,
student enrollment, or
historical tracking.
Partially supported
your answer by
providing specific
business functions
that these reports
could assist
executives of the
university.
Competent (80-89%)
Satisfactorily
suggested at least
four types of business
intelligence reports
that could help the
university in course
management, student
enrollment, or
historical tracking.
Supported your
answer by providing
specific business
functions that these
reports could assist
executives of the
university.
Exemplary (90-100%)
Thoroughly suggested
at least four types of
business intelligence
reports that could help
the university in
course management,
student enrollment, or
historical tracking.
Supported your
answer by providing
specific business
functions that these
reports could assist
executives of the
university.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Suggest three vendors that developed and are employing efficient registrar and school management
database systems and support your reasons to choose from one of these three vendors. 15 %
Unacceptable (Below
70%)
Did not submit or
incompletely
suggested three
vendors that
developed and are
employing efficient
registrar and school
management
database systems
and did not support
your reasons to
choose from one of
these three vendors.
Needs Improvement (70-
79%)
Partially suggested
three vendors that
developed and are
employing efficient
registrar and school
management
database systems
and partially
supported your
reasons to choose
from one of these
three vendors.
Competent (80-89%)
Satisfactorily
suggested three
vendors that
developed and are
employing efficient
registrar and school
management
database systems
and supported your
reasons to choose
from one of these
three vendors.
Exemplary (90-100%)
Thoroughly suggested
three vendors that
developed and are
employing efficient
registrar and school
management
database systems
and supported your
reasons to choose
from one of these
three vendors.
Compare and contrast the key aspects that each system offers. 15 %
Unacceptable (Below
70%)
Did not submit or
incompletely
compared and
contrasted the key
aspects that each
system offers.
Needs Improvement (70-
79%)
Partially compared
and contrasted the
key aspects that each
system offers.
Competent (80-89%)
Satisfactorily
compared and
contrasted the key
aspects that each
system offers.
Exemplary (90-100%)
Thoroughly compared
and contrasted the
key aspects that each
system offers.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Provide three references. 5 %
Unacceptable (Below
70%)
No references
provided.
Needs Improvement (70-
79%)
Did not meet the
required number of
references; some
references were poor-
quality choices.
Competent (80-89%)
Met the required
number of references;
all references were
high-quality choices.
Exemplary (90-100%)
Exceeded the
required number of
references; all
references were high-
quality choices.
Clarity, writing mechanics, and formatting requirements. 10 %
Unacceptable (Below
70%)
More than 6 errors
present.
Needs Improvement (70-
79%)
5–6 errors present.
Competent (80-89%)
3–4 errors present.
Exemplary (90-100%)
0–2 errors present.
Week 5 Assignment - Database Modeling and Normalization
Summary
Click the linked activity title to access this assignment.
Before handing in your assignment, make sure that you have:
Reviewed the instructions.
Asked questions early and often!
Used feedback you have received on other assignments while working on this one.
Text
Overview
Imagine that you work for a consulting firm that offers information technology and database services.
Part of its core services is to optimize and offer streamlined solutions for efficiency. In this scenario,
your firm has been awarded a contract to implement a new personnel system for a government
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
agency. This government agency has requested an optimized data repository for its system, which
will enable the management staff to perform essential human resources (HR) duties along with the
capability to produce ad hoc reporting features for various departments. They look forward to
holding data that will allow them to perform HR core functions such as hiring, promotions, policy
enforcement, benefits management, and training.
Instructions
Using this scenario, write a 3–4 page paper in which you:
Determine the steps in the development of an effective entity relationship model (ERM)
diagram and determine the possible iterative steps and factors that one must consider in this
process, with consideration of the HR core functions and responsibilities of the client.
Analyze the risks that can occur if any of the developmental or iterative steps of creating an
ERM diagram are not performed.
Select and rank at least five entities that would be required for the development of the data
repositories.
Specify the components that would be required to hold time-variant data for policy
enforcement and training management.
Diagram a possible 1:M solution that will hold salary history data, job history, and training
history for each employee through the use of graphical tools. Note: The graphically depicted
solution is not included in the required page length.
Plan each step of the normalization process to ensure the 3NF level of normalization using the
selected five entities of the personnel database solution. Document each step of the process
and justify your assumptions in the process.
Diagram at least five possible entities that will be required to sustain a personnel solution.
(Note: The graphically depicted solution is not included in the required page length.) The
diagram should include the following:
Dependency diagrams.
Multivalued dependencies.
The cover page and the reference page are not included in the required assignment page
length. Include charts or diagrams created in any chart or drawing tool with which you are
familiar. The completed diagrams or charts must be imported into the Word document before
the paper is submitted.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
This course requires the use of Strayer Writing Standards. For assistance and information, please
refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your
professor for any additional instructions.
The specific course learning outcome associated with this assignment is:
Create a database using normalization techniques and logical/physical design best practices.
Scoring Guide
Determine the steps in the development of an effective entity relationship model (ERM) diagram and
determine the possible iterative steps and factors that one must consider in this process, with
consideration of the HR core functions and responsibilities of the client. 15 %
Unacceptable (Below
70%)
Did not submit or
incompletely
determined the steps
in the development of
an effective ERM
diagram and/or did
not determine the
possible iterative
steps/factors that one
must consider in this
process with
consideration of the
HR core functions and
responsibilities of the
client.
Needs Improvement (70-
79%)
Partially determined
the steps in the
development of an
effective ERM
diagram and/or
partially determined
the possible iterative
steps/factors that one
must consider in this
process, with
consideration of the
HR core functions and
responsibilities of the
client.
Competent (80-89%)
Satisfactorily
determined the steps
in the development of
an effective ERM
diagram and
determined the
possible iterative
steps/factors that one
must consider in this
process with
consideration of the
HR core functions and
responsibilities of the
client.
Exemplary (90-100%)
Thoroughly
determined the steps
in the development of
an effective ERM
diagram and
determined the
possible iterative
steps/factors that one
must consider in this
process with
consideration of the
HR core functions and
responsibilities of the
client.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Analyze the risks that can occur if any of the developmental or iterative steps of creating an ERM
diagram are not performed. 10 %
Unacceptable (Below
70%)
Did not submit or
incompletely analyzed
the risks that can
occur if any of the
developmental or
iterative steps of
creating an ERM
diagram are not
performed.
Needs Improvement (70-
79%)
Partially analyzed the
risks that can occur if
any of the
developmental or
iterative steps of
creating an ERM
diagram are not
performed.
Competent (80-89%)
Satisfactorily
analyzed the risks that
can occur if any of the
developmental or
iterative steps of
creating an ERM
diagram are not
performed.
Exemplary (90-100%)
Thoroughly analyzed
the risks that can
occur if any of the
developmental or
iterative steps of
creating an ERM
diagram are not
performed.
Select and rank at least five entities that would be required for the development of the data
repositories. 10 %
Unacceptable (Below
70%)
Did not submit or
incompletely selected
and ranked at least
five entities that would
be required for the
development of the
data repositories.
Needs Improvement (70-
79%)
Partially selected and
ranked at least five
entities that would be
required for the
development of the
data repositories.
Competent (80-89%)
Satisfactorily selected
and ranked at least
five entities that would
be required for the
development of the
data repositories.
Exemplary (90-100%)
Thoroughly selected
and ranked at least
five entities that would
be required for the
development of the
data repositories.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Specify the components that would be required to hold time-variant data for policy enforcement and
training management. 10 %
Unacceptable (Below
70%)
Did not submit or
incompletely specified
the components that
would be required to
hold time-variant data
for policy enforcement
and training
management.
Needs Improvement (70-
79%)
Partially specified the
components that
would be required to
hold time-variant data
for policy enforcement
and training
management.
Competent (80-89%)
Satisfactorily specified
the components that
would be required to
hold time-variant data
for policy enforcement
and training
management.
Exemplary (90-100%)
Thoroughly specified
the components that
would be required to
hold time-variant data
for policy enforcement
and training
management.
Diagram a possible 1:M solution that will hold salary history data, job history, and training history for
each employee through the use of graphical tools. 15 %
Unacceptable (Below
70%)
Did not submit or
incompletely
diagrammed a
possible 1:M solution
that will hold salary
history data, job
history, and training
history for each
employee through the
use of graphical tools.
Needs Improvement (70-
79%)
Partially diagrammed
a possible 1:M
solution that will hold
salary history data,
job history, and
training history for
each employee
through the use of
graphical tools.
Competent (80-89%)
Satisfactorily
diagrammed a
possible 1:M solution
that will hold salary
history data, job
history, and training
history for each
employee through the
use of graphical tools.
Exemplary (90-100%)
Thoroughly
diagrammed a
possible 1:M solution
that will hold salary
history data, job
history, and training
history for each
employee through the
use of graphical tools.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Plan each step of the normalization process to ensure the 3NF level of normalization using the
selected five entities of the personnel database solution. Document each step of the process and
justify your assumptions in the process. 20 %
Unacceptable (Below
70%)
Did not submit or
incompletely planned
each step of the
normalization process
to ensure the 3NF
level of normalization
using the selected five
entities of the
personnel database
solution.
Needs Improvement (70-
79%)
Partially planned each
step of the
normalization process
to ensure the 3NF
level of normalization
using the selected five
entities of the
personnel database
solution. Documented
each step of the
process and justified
your assumptions in
the process.
Competent (80-89%)
Satisfactorily planned
each step of the
normalization process
to ensure the 3NF
level of normalization
using the selected five
entities of the
personnel database
solution. Documented
each step of the
process and justified
your assumptions in
the process.
Exemplary (90-100%)
Thoroughly planned
each step of the
normalization process
to ensure the 3NF
level of normalization
using the selected five
entities of the
personnel database
solution. Documented
each step of the
process and justified
your assumptions in
the process.
Diagram at least five possible entities that will be required to sustain a personnel solution. Include the
dependency diagrams in your diagram. 5 %
Unacceptable (Below
70%)
Did not submit or
incompletely
diagrammed at least
five possible entities
that will be required to
sustain a personnel
solution. Did not
include the
dependency
diagrams.
Needs Improvement (70-
79%)
Partially diagrammed
at least five possible
entities that will be
required to sustain a
personnel solution.
Included the
dependency diagrams
in your diagram.
Competent (80-89%)
Satisfactorily
diagrammed at least
five possible entities
that will be required to
sustain a personnel
solution. Included the
dependency diagrams
in your diagram.
Exemplary (90-100%)
Thoroughly
diagrammed at least
five possible entities
that will be required to
sustain a personnel
solution. Included the
dependency diagrams
in your diagram.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Diagram at least five possible entities that will be required to sustain a personnel solution. Include
multivalued dependencies in your diagram. 5 %
Unacceptable (Below
70%)
Did not submit or
incompletely
diagrammed at least
five possible entities
that will be required to
sustain a personnel
solution. Did not
include multivalued
dependencies in your
diagram.
Needs Improvement (70-
79%)
Partially diagrammed
at least five possible
entities that will be
required to sustain a
personnel solution.
Included multivalued
dependencies in your
diagram.
Competent (80-89%)
Satisfactorily
diagrammed at least
five possible entities
that will be required to
sustain a personnel
solution. Included
multivalued
dependencies in your
diagram.
Exemplary (90-100%)
Thoroughly
diagrammed at least
five possible entities
that will be required to
sustain a personnel
solution. Included
multivalued
dependencies in your
diagram.
Clarity, writing mechanics, and formatting requirements. 10 %
Unacceptable (Below
70%)
More than 6 errors
present.
Needs Improvement (70-
79%)
5–6 errors present.
Competent (80-89%)
3–4 errors present.
Exemplary (90-100%)
0–2 errors present.
Week 7 Assignment 1 - Submit Creating Base Relation for the ProAudio Database Lab
Summary
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Text
How to Submit Your Lab Results
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Note: Failure to submit your lab results into the assignment submission area within the Strayer
Blackboard courseroom will result in 0 points for the assignment. Evidence of purposely skipped
answers, incomplete answers, or limited effort is at the instructor's discretion and may result in
partial or incomplete credit for the assignment.
Scoring Guide
Complete the lab and submit with required materials. 100 %
Unacceptable
Did not complete or submit the lab.
Exemplary
Successfully completed the lab and submitted
with all required materials.
Week 7 Assignment 2 - Submit Creating Relations and Adding CHECK Constraints Lab
Summary
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Text
How to Submit Your Lab Results
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Note: Failure to submit your lab results into the assignment submission area within the Strayer
Blackboard courseroom will result in 0 points for the assignment. Evidence of purposely skipped
answers, incomplete answers, or limited effort is at the instructor's discretion and may result in
partial or incomplete credit for the assignment.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Scoring Guide
Complete the lab and submit with required materials. 100 %
Unacceptable
Did not complete or submit the lab.
Exemplary
Successfully completed the lab and submitted
with all required materials.
Week 8 Assignment 1 - Submit Using the INSERT Statement Lab
Summary
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Text
How to Submit Your Lab Results
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Note: Failure to submit your lab results into the assignment submission area within the Strayer
Blackboard courseroom will result in 0 points for the assignment. Evidence of purposely skipped
answers, incomplete answers, or limited effort is at the instructor's discretion and may result in
partial or incomplete credit for the assignment.
Scoring Guide
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Complete the lab and submit with required materials. 100 %
Unacceptable
Did not complete or submit the lab.
Exemplary
Successfully completed the lab and submitted
with all required materials.
Week 8 Assignment 2 - Submit Using DDL Lab
Summary
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Text
How to Submit Your Lab Results
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Note: Failure to submit your lab results into the assignment submission area within the Strayer
Blackboard courseroom will result in 0 points for the assignment. Evidence of purposely skipped
answers, incomplete answers, or limited effort is at the instructor's discretion and may result in
partial or incomplete credit for the assignment.
Scoring Guide
Complete the lab and submit with required materials. 100 %
Unacceptable
Did not complete or submit the lab.
Exemplary
Successfully completed the lab and submitted
with all required materials.
Week 8 Assignment 3 - Submit Deleting and Updating Records Lab
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Summary
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Text
How to Submit Your Lab Results
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Note: Failure to submit your lab results into the assignment submission area within the Strayer
Blackboard courseroom will result in 0 points for the assignment. Evidence of purposely skipped
answers, incomplete answers, or limited effort is at the instructor's discretion and may result in
partial or incomplete credit for the assignment.
Scoring Guide
Complete the lab and submit with required materials. 100 %
Unacceptable
Did not complete or submit the lab.
Exemplary
Successfully completed the lab and submitted
with all required materials.
Week 8 Assignment 4 - Submit Using the IN, BETWEEN, and LIKE Operators Lab
Summary
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Text
How to Submit Your Lab Results
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Note: Failure to submit your lab results into the assignment submission area within the Strayer
Blackboard courseroom will result in 0 points for the assignment. Evidence of purposely skipped
answers, incomplete answers, or limited effort is at the instructor's discretion and may result in
partial or incomplete credit for the assignment.
Scoring Guide
Complete the lab and submit with required materials. 100 %
Unacceptable
Did not complete or submit the lab.
Exemplary
Successfully completed the lab and submitted
with all required materials.
Week 8 Assignment 5 - Submit Retrieving Records From a Database Lab
Summary
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Text
How to Submit Your Lab Results
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Note: Failure to submit your lab results into the assignment submission area within the Strayer
Blackboard courseroom will result in 0 points for the assignment. Evidence of purposely skipped
answers, incomplete answers, or limited effort is at the instructor's discretion and may result in
partial or incomplete credit for the assignment.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Scoring Guide
Complete the lab and submit with required materials. 100 %
Unacceptable
Did not complete or submit the lab.
Exemplary
Successfully completed the lad and submitted
with all required materials.
Week 9 Assignment - Submit Joining Relations Lab
Summary
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Text
How to Submit Your Lab Results
Click the linked activity title to submit this assignment. See uCertify in the left-hand menu for
submission instructions.
Note: Failure to submit your lab results into the assignment submission area within the Strayer
Blackboard courseroom will result in 0 points for the assignment. Evidence of purposely skipped
answers, incomplete answers, or limited effort is at the instructor's discretion and may result in
partial or incomplete credit for the assignment.
Scoring Guide
Complete the lab and submit with required materials. 100 %
Unacceptable
Did not complete or submit the lab.
Exemplary
Successfully completed the lab and submitted
with all required materials.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Week 10 Assignment - Case Study
Summary
Click the linked activity title to access this assignment.
Before you turn in this assignment, make sure that you:
Review the instructions.
Start reading early (there are quite a few articles).
Ask questions, as often as you need to.
Use feedback you have received on other assignments while working on this one.
Text
Overview
Read the following articles and incorporate them into your paper. You are encouraged to review
additional articles as well.
An Introduction of NoSQL Databases Based on Their Categories and Application Industries.
Software Development Lifecycle for Energy Efficiency: Techniques and Tools.
First Things First: Adopting a Holistic, Needs-Driven Approach to Improving the Quality of
Routinely Collected Data.
Approaches to Speed Up Data Processing in Relational Databases.
Instructions
Write a 2–3 page paper in which you:
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Recommend at least three specific tasks that could be performed to improve the quality of data
sets using the software development life cycle (SDLC) methodology. Include a thorough
description of each activity per each phase.
Recommend the actions that should be performed to optimize record selections and to
improve database performance from a quantitative data quality assessment.
Suggest three maintenance plans and three activities that could be performed to improve data
quality.
Suggest methods that would be efficient for planning proactive concurrency control methods
and lock granularities. Assess how your selected method can be used to minimize the
database security risks that may occur within a multiuser environment.
Analyze how the method can be used to plan out the system effectively and ensure that the
number of transactions does not produce record-level locking while the database is in
operation.
Go to the Strayer Library to find at least three quality resources in this assignment.
This course requires the use of Strayer Writing Standards. For assistance and information, please
refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your
professor for any additional instructions.
The specific course learning outcome associated with this assignment is:
Recommend strategies to minimize security risk and improve database performance.
Scoring Guide
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Recommend at least three specific tasks that could be performed to improve the quality of data sets
using the software development life cycle (SDLC) methodology. Include a thorough description of
each activity per each phase. 15 %
Unacceptable (Below
70%)
Did not submit or
incompletely
recommended at least
three specific tasks
that could be
performed to improve
the quality of data
sets using the SDLC
methodology. Did not
include a thorough
description of each
activity per each
phase.
Needs Improvement (70-
79%)
Partially
recommended at least
three specific tasks
that could be
performed to improve
the quality of data
sets using the SDLC
methodology.
Included a partial
description of each
activity per each
phase.
Competent (80-89%)
Satisfactorily
recommended at least
three specific tasks
that could be
performed to improve
the quality of data
sets using the SDLC
methodology.
Included a thorough
description of each
activity per each
phase.
Exemplary (90-100%)
Thoroughly
recommended at least
three specific tasks
that could be
performed to improve
the quality of data
sets using the SDLC
methodology.
Included a thorough
description of each
activity per each
phase.
Recommend the actions that should be performed to optimize record selections and to improve
database performance from a quantitative data quality assessment. 20 %
Unacceptable (Below
70%)
Did not submit or
incompletely
recommended the
actions that should be
performed to optimize
record selections and
to improve database
performance from a
quantitative data
quality assessment.
Needs Improvement (70-
79%)
Partially
recommended the
actions that should be
performed to optimize
record selections and
to improve database
performance from a
quantitative data
quality assessment.
Competent (80-89%)
Satisfactorily
recommended the
actions that should be
performed to optimize
record selections and
to improve database
performance from a
quantitative data
quality assessment.
Exemplary (90-100%)
Thoroughly
recommended the
actions that should be
performed to optimize
record selections and
to improve database
performance from a
quantitative data
quality assessment.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Suggest three maintenance plans and three activities that could be performed to improve data quality.
20 %
Unacceptable (Below
70%)
Did not submit or
incompletely
suggested three
maintenance plans
and three activities
that could be
performed to improve
data quality.
Needs Improvement (70-
79%)
Partially suggested
three maintenance
plans and three
activities that could be
performed to improve
data quality.
Competent (80-89%)
Satisfactorily
suggested three
maintenance plans
and three activities
that could be
performed to improve
data quality.
Exemplary (90-100%)
Thoroughly suggested
three maintenance
plans and three
activities that could be
performed to improve
data quality.
Suggest methods that would be efficient for planning proactive concurrency control methods and lock
granularities. Assess how your selected method can be used to minimize the database security risks
that may occur within a multiuser environment. 15 %
Unacceptable (Below
70%)
Did not submit or
incompletely
suggested methods
that would be efficient
for planning proactive
concurrency control
methods and lock
granularities. Did not
assess how your
selected method can
be used to minimize
the database security
risks that may occur
within a multiuser
environment.
Needs Improvement (70-
79%)
Partially suggested
methods that would
be efficient for
planning proactive
concurrency control
methods and lock
granularities.
Assessed how your
selected method can
be used to minimize
the database security
risks that may occur
within a multiuser
environment.
Competent (80-89%)
Satisfactorily
suggested methods
that would be efficient
for planning proactive
concurrency control
methods and lock
granularities.
Assessed how your
selected method can
be used to minimize
the database security
risks that may occur
within a multiuser
environment.
Exemplary (90-100%)
Thoroughly suggested
methods that would
be efficient for
planning proactive
concurrency control
methods and lock
granularities.
Assessed how your
selected method can
be used to minimize
the database security
risks that may occur
within a multiuser
environment.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Analyze how the method can be used to plan out the system effectively and ensure that the number of
transactions does not produce record-level locking while the database is in operation. 15 %
Unacceptable (Below
70%)
Did not submit or
incompletely analyzed
how the method can
be used to plan out
the system effectively
and ensure that the
number of
transactions does not
produce record-level
locking while the
database is in
operation.
Needs Improvement (70-
79%)
Partially analyzed
how the method can
be used to plan out
the system effectively
and ensure that the
number of
transactions does not
produce record-level
locking while the
database is in
operation.
Competent (80-89%)
Satisfactorily
analyzed how the
method can be used
to plan out the system
effectively and ensure
that the number of
transactions does not
produce record-level
locking while the
database is in
operation.
Exemplary (90-100%)
Thoroughly analyzed
how the method can
be used to plan out
the system effectively
and ensure that the
number of
transactions does not
produce record-level
locking while the
database is in
operation.
Use at least three quality resources in this assignment. 5 %
Unacceptable (Below
70%)
No references
provided.
Needs Improvement (70-
79%)
Did not meet the
required number of
references; some
references were poor-
quality choices.
Competent (80-89%)
Met the required
number of references;
all references were
high-quality choices.
Exemplary (90-100%)
Exceeded the
required number of
references; all
references were high-
quality choices.
Clarity, writing mechanics, and formatting requirements. 10 %
Unacceptable (Below
70%)
More than 6 errors
present.
Needs Improvement (70-
79%)
5–6 errors present.
Competent (80-89%)
3–4 errors present.
Exemplary (90-100%)
0–2 errors present.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written
permission of Strayer University.
2022 Strategic Education, Inc., Version 3
Students also viewed