Diagramming a Database Design NURS 6412

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.