SXM1 TASK 2: ENTITY RELATIONSHIP DIAGRAM DATA MODELING & DATABASE MANAGEMENT SYSTEMS — C792 PRFA

REQUIREMENTS
Your submission must be your original work. No more than a combined total of 30% of the
submission and no more than a 10% match to any one individual source can be directly quoted or
closely paraphrased from sources, even if cited correctly. The similarity report that is provided when
you submit your task can be used as a guide.
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.
Tasks may not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive,
etc., unless specified in the task requirements. All other submissions must be file types that are
uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
For this assessment you will create a logical ERD through Microsoft Visio or another drawing tool,
using the “Code Sheet for ERD” supporting document. You will then write a paper reflecting on your
experience.
10/8/21, 3:28 PM WGU Performance Assessment
https://tasks.wgu.edu/student/001039036/course/22740014/task/3154/overview 3/7
A. Create a logical ERD with a parent table, a child table, and three lookup tables by doing the
following:
1. Create one parent table that incorporates the following components:
• table name
• primary key
• field names
2. Create one child table that incorporates the following components:
• table name
• primary and foreign keys
• field names
3. Create three lookup tables that each incorporate the following components:
• table names
• correct response options in the lookup table
4. Indicate the relationships between the tables with ordinality and cardinality using crow’s foot
notation.
B. Reflect (suggested length of 4–5 pages) on your experiences modeling a database by doing the
following:
1. Embed a screenshot of the ERD diagram you created.
2. Explain how your thinking regarding data modeling and database management systems
evolved while working on this task, including specific examples.
3. Explain how the survey information could be shared if a patient is seen outside of the health
system network by addressing the following points:
a. Explain how interoperability supports the sharing of information between electronic
health record systems.
b. Explain a regulatory mechanism that ensures the privacy of protected health information
(PHI) when sharing information.
4. Describe a CDS alert that could be created to support this project, and include the following:
● which clinicians would see the alert
● when the CDS alert would appear (i.e., trigger) for a clinician
● what the CDS alert would say
● the reasoning for or against the CDS alert being a hard stop for clinicians
5. Explain how the knowledge and skills you have acquired during this course inform your
understanding of the roles and responsibilities of a nurse informaticist in a work setting.
C. Incorporate the following components of APA style and formatting into your paper:
● bias-free language
● objectivity, credibility of sources, and an evidence-based approach
● APA-specific rules regarding verb tense, voice, and perspective
● APA-specific formatting rules for in-text citations and references, margins, spacing,
numbering, and indentation for the title page, main body, and appendices of your paper,
including headers, bulleted and numbered lists, and tables and figures
D. Demonstrate professional communication in the content and presentation of your submission.