Database Plan
For 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.
To prepare:
• 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.
• 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?
To complete:
In a 3- to 5-page paper, address the following:
• The clinical question you want the database to answer. "Does implementation of an established, evidence-based falls risk assessment tool reduce patient falls in the acute care setting?"
• The data elements (inputs) needed to answer the question.
• A description of the different tables you will use. Note: Make sure to have an appropriate number of tables to organize the data needed to answer your question in a meaningful, effective way.
• Each field name and field type.
• Which fields belong in which tables.
• Primary key fields and foreign key fields where needed.
• An entity relationship diagram for your clinical question. [Include this diagram as an appendix to the paper.]
• A brief summary of how your team plans to secure the database and protect the data it contains.
• A brief summary of your experience in developing the different elements of the database. What problems did you encounter? Did anything surprise you?
Your written assignments must follow APA guidelines.
• Create your paper with two heading levels: one level for the title and the second level for subheadings that identify each section.
• Include your entity relationship diagram as an appendix.
• Follow the guidelines for in-text citations and for creating a reference list. Place your reference list at the end of this section.
Attachment:- Data_For_Access_DB.xlsx