Subject: Food.

Write a well-developed, well supported argumentative paper of at least four but no more than six pages with at least three valid outside sources for support for one of the general topics listed below. paper should argue for, against, or a combination of both points with an effective outcome.

this assignment should be done in 10 hours.

Part 1:

For this part of the assignment, you will use the “AdventureWorks 2014 OLTP Database,” located in the Course Materials, and use the schema. Follow the tree/chain to answer the questions below in a Microsoft Word document.

1. How does the Sales.SalesTerritory table relate to the Person.StateProvince table? Which table holds the Primary and the Foreign Key? On what field do they join together?
2. If you wanted to know the Planned Cost of a Product, what route would you take to the data? Identify the tables and fields used to join on each.
3. Imagine a bonus was paid to an employee using a different currency. Identify the fields you would need so you could access the information. List all the tables involved, and the fields used to join.

Part 2:

For this part of the assignment, you will continue to assume you work at Adventure Works Cycles company. In the Topic 1 assignment, you made a request to add a field to the company database. That request has been approved, and now the database diagram needs to be accurately updated.

Create a simple Entity-Relationship Diagram ERD (using Draw.io or another similar application as approved by instructor) demonstrating how your new table will connect to the “HumanResources.Employee” table on the diagram. Since this is a new table, add new fields to create the proper relationships as you see fit.

In a one to two paragraph Word document, explain how these fields relate to the rest of the database content.

Compile the ERD file and Word document into a .zip file and submit to your instructor.

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/ms124438(v=sql.100)

 

 

Analyze and explain the two new technologies that have affected health care in the past five years.

 

Analyze and describe the two new technologies that will be needed in the years ahead to keep up with the aging baby boomers.

 

 

please cite your sources in your work and provide references for the citations in APA format.

As a nurse engaged in evidence-based practice, it is important to recognize how statistics and other data analysis tools are used to generate and assess evidence. Most nurses need only a foundational understanding of statistical tools and terminology to understand the majority of research studies. As a nurse, you should be able to recognize the most commonly used statistical tests, how and when they are used, and how significance is determined.

In this Discussion, you examine different types of statistics and statistical tests, when and why these particular tests would be selected for use, and, most importantly, what the results indicate. 

 

To prepare:

·         Review the information in your assigned chapter (Chapter 23, “Qualitative Data Analysis”)

Polit, D. F., & Beck, C. T. (2012).  Nursing research: Generating and assessing evidence for nursing practice (Laureate Education, Inc., custom ed.). Philadelphia, PA: Lippincott Williams & Wilkins.

·         Develop a 1-page study sheet that includes the following:

o    The key concepts of the chapter: Focus on the basic concepts that are important for nurses to understand as they review research studies. Discuss why it is important for nurses to understand the basics of these statistical methods.

o    A description of the statistical methods covered in the chapter, what they measure, and under what circumstances they are used. Identify examples of how the statistical methods have been used in research studies.

o    An explanation of the key statistical tests and how they measure significance (if applicable).

Readings

·         Polit, D. F., & Beck, C. T. (2012).  Nursing research: Generating and assessing evidence for nursing practice (Laureate Education, Inc., custom ed.). Philadelphia, PA: Lippincott Williams & Wilkins.

 

Chapter 23, “Qualitative Data Analysis”

The focus of this chapter is qualitative data analysis, which is more difficult in some ways than quantitative analysis, because there are not specific tests that can be used. Instead, much of the analysis is based on the researcher’s ability to identify patterns of behavior or similarities in events. Suggestions are provided for analysis of each of the major types of qualitative studies and how to document findings.