Blueprints are used by others besides architects. New home buyers may use the blueprint of their future home to better understand the architect’s vision and to consult with the architect on changes. Municipalities will use the blueprint to issue building permits. Builders will use it to plan construction and estimate costs.
Likewise, you don’t have to be a database designer to apply visual tools such as database diagrams. For example, creating or studying a database diagram can help you, as a leader in a healthcare organization, understand the data needs of the organization or of your team.
This is in turn can create efficiencies and drive improvements at varied levels of patient care. As a nurse, database diagrams can help you analyze the data structure and how to make best use of the available data and functionality in the provision of care. At every level of an organization, an understanding of database diagrams can help in providing feedback to database managers that in turn can help drive improvements.
In your Module 2 Assignment, you create a database diagram for the database that you proposed in the Week 3 Discussion and built upon in the Week 4 Discussion. You also create a PICOT question to be used to search your proposed database. Finally, you develop an analysis of your database design, explaining the proposed structure and design elements while justifying your approach.
- Review the Learning Resources.
- Review your posts from the Weeks 3 and 4 Discussions and the scenario on which they are based.
- Consider a clinical research question you might ask that could be informed by the data in your database.
- Restate your clinical question as a PICOT question.
Assignment (2- to 3-page paper and a diagram of a database as an appendix):
Using the scenario from Week 3, create a diagram of your proposed database using Microsoft Word.
- Include the additions made in Week 4.
- Complete the diagram first, but place it as the final page or pages of your submission. The diagram is separate from the required page count.
In the narrative portion of the assignment:
- Explain how your diagram articulates your planned design.
- Explain the principles behind selecting key fields and defining relationships. Be specific and support your response with evidence.
- Write a sample PICOT question (i.e., a query) you might ask based on the information in the database created during Weeks 3 and 4 to demonstrate your understanding of the connection between data and research.
- List the tables in the database that you would need to include when answering your question.
- The scenario: You are a member of a hospital committee to increase retention among nurses. You are tasked with compiling the data from exit interviews to look for trends in the reasons for why nurses are leaving various departments.
Collecting the data from exit interviews will assist in identifying trends in why RN are leaving various departments. An efficient database to utilize in collecting data from exit interviews is an HR database. The data from the exit interviews can be placed on an IE diagram to organize the results from the interviews. The IE diagram uses lines to show the relationships among entities and the end of the lines have crow feet which indicate mandatory relationships (Harrington, 2016). After completing the IE diagram, a table can be created to show the results and assist in demonstrating trends in the reasons why nurses are leaving various departments. The table will consist of rows and each row indicates a reason nurses reported in the exit interview such as management issues, workload, salary, and lack of advancement. The table columns will demonstrate the different departments such as Med-Surg, ICU, OB, Peds, and ER. This information will give the hospital a better understanding of which departments have a higher percentage of nurse turnover and the reasons. Converting the exit interview data from paper to electronic is very critical on improving deficiencies or gaps in the hospital. Electronic data provides the hospital faster access to data, accurate, and saves the hospital staff on organizing data.
In a relational data model, design issues can occur in many-to-many relationships. The relational data model is unable to directly support many-to-many relationships. Therefore, the many-to-many relationships in the database must be substituted with one-to-many relationships (Harrington, 2016). To organize my data, I would adjust my design by adding another table and in that table, I would have rows indicating the nurse’s name, employee number, age, sex, salary, unit, and the number of years the nurse has worked at the organization.
Demographics Table (name of table) Field Name Data Type MR Number Number First Name Text Last Name Text Date of Birth Date & Time Active Yes/No
One to many relationships. One person (demographic table) may have many allergies (allergy table)
Allergy Table Field Name Data Type MR Number Number Generic Medicine Name Text Reaction Type Text Date of Reaction Date & Time Reaction Level Text
Show the relationship between the tables.