What is the rate of pneumonia for patients who receive Vaccine X?”For Part 2 of your Team Database Project, you will plan a relational database that will address a simple, specific clinical question related to health care or nursing.
For Part 2 of your Team Database Project, you will plan a relational database that will address a simple, specific clinical question related to health care or nursing. You will determine this question and then write a paper describing in detail the database you plan to design based on your question. Your ultimate goal (Part 3) in this Team Database Project is to create a database using Microsoft Access that can answer a simple clinical question. Plan carefully to ensure that you will gather a sufficient amount of appropriate information. The project is being introduced to you this week so that when you go through the actual steps of designing and building a database, you will already have your question in mind, and thus, be better prepared to address it.
In database design, identifying the question to be asked is the most important activity. If the designers do not understand what the client wants out of the database, the database will not be useful. Time and money will be wasted. In the real world, designers return to the client at each stage of development to make sure the design is on track.
Make sure all of the team understands what questions are to be asked of the database and what type of answers you are seeking. Use plain English. Don’t worry about using a query language.
Submit ONE 3- to 5-page paper that synthesizes all of the relevant ideas and contributions. The paper is due by Sunday 07/03/2016 before midnight.
Review this week’s Learning Resources and conduct additional online research about databases and clinical information. Share your understanding and the outside sources you find with your team members.
Come to a consensus about the particular topic or area of interest to be the focus of your database.
Discuss possible clinical questions that could be answered by information in your database and by focusing on the topic or area you agreed upon. Be sure that the questions are simple, specific, and related to patient care. For example, a possible question could be “What is the rate of pneumonia for patients who receive Vaccine X?”
Come to an agreement on which question you will use as the focus of your database design. Remember that this question should be relatively simple; it should not be a question that would be appropriate for a research project or a large-scale study.
Consider your question as the output for the database you will design in Part 3. Reflect on why it is important to determine the output(s) for a database before determining the required input(s).
Based on the question your team selected, collaborate with your team members to determine the data (inputs) that the database will need. The input(s) should be directly related to answering the question your team selected.
Draft an entity relationship diagram for the question you selected. Review the examples provided in the Coronel text, e.g. Figure 2.3 on page 43. You may opt to use any of the three types of entity relationship model notations demonstrated.