Skip to content
- 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.
- Consult with your team members on how you can ensure the security of the database your team plans to design. How will your team protect the data contained in the database?
