Database plan | Computer Science homework help



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.


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 (due by Sunday 07/03/2016):

    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.



Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more