Discussion: Creating a 1:M Relationship Between Order and Medication

Discussion: Creating a 1:M Relationship Between Order and Medication

Start Date & Time Due Date & Time Points
Jan 20, 2022, 12:00 AM Jan 24, 2022, 11:59 PM 5
Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor.
Because the patient often receives several medications per day, there is a 1:M relationship
Page 6 Grand Canyon University 2022 © Prepared on: Jan 10, 2022
between patient and order. Similarly, each order can include several medications, creating a 1:M relationship
between order and medication.
1. Identify different entities from this scenario.
2. Create an entity-relationship diagram illustrating 1:1 and 1: many relationships.
3. Compare your ERD with another classmate’s and discuss the differences each of you had.

The purpose of this assignment is to provide learners a basic understanding for identifying a database project
proposal for collecting data and for designing and developing a small database that can be used to compile
and report clinical data related to either quality measures or pharmaceutical products and utilization.
There are three parts to the database project proposal. The initial step involves identifying an idea for a
database and describing its purpose. The second part allows you to design the database components. The
third part requires you to present the database proposal to stakeholders. Feedback from the instructor at
Page 5 Grand Canyon University 2022 © Prepared on: Jan 10, 2022
every stage will help you make improvements in the database project.

To complete Part 1 of the Database Project Proposal assignment, create a 500-750-word proposal outlining the
following elements:
1. Statement of the project problem and defnition of terms.
2. Identify database users (personnel/credentials): Who are they? What are their competencies and
background?
3. Discuss the types of data that users will collect for the proposed database and describe at least three
reports that will be generated for analysis. Explain their use and who will use the reports?
4. Describe the project goals and clear measurable objectives for the database. Identify the steps you will take
to meet the goals and objectives.
5. Forecast any potential problems or barriers to meeting the project goals and objectives. Are there any
specifc assumptions that need to be made?
6. Discuss data communications protocols that could be used in your database project. Refer to the
“Blockchain Personal Health Records: Systematic Review” article, provided in the topic Resources.
7. Conclude with the value of the project with emphasis on feasibility and the beneft of the expected results.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student
Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar
with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is
located in Class Resources if you need assistance.
CAHIIM
This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the
master’s degree level:
F1: Health: Shows How
F2: Information Science and Technology: Shows How
F4: Health Information Science and Technology: Shows How