Database Management – SQL Tutorial (Due 11 Dec) (4 Pages) (3 References)

Requirements:

1) APA 6th Ed format

2 ) Due 11 Dec 

3) 3-4 Pages (not including title page and references)

4) 3 References

5) Plagiarism-Free

Background:

For this module, your task is to try the tutorial W3schools.com SQL Tutorial  ( https://www.w3schools.com/sql/default.asp ) This is described as:

This unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. You will receive immediate results after submitting your SQL commands. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. This SQL tutorial currently supports a subset of ANSI SQL. The basics of each SQL command will be covered in this introductory tutorial. Unless otherwise stated, the interpreter will support everything covered in this course.

The more of the tutorial you can work through, the better; however, your grade is primarily dependent on how you approach the task and how much learning energy you put into it rather than the specific output from the tutorial.

Assignment:

Once you have completed your exploration of the tutorial, you are to prepare a review of the tutorial, like the kind of review that you would find in a good computer/information systems journal or website, covering the following topics:

  • what the tutorial taught you and what you learned specifically from the tutorial (>75% of your write-up)
  • how effective was the tutorial, who might find the tutorial useful, and any other aspect of the tutorial that you think a reader might find useful

Your paper should be three to four pages in length, and reflect your personal experiences with this issue. The important part of all these project assignments is to carefully assess your own experiences with the topic, and then reflect critically on what you might have learned about yourself and about situations through this assessment process.

The more that you can use the exercise to develop personal implications for your growth as a potential business person as well as a moral individual, the more value you’ll get out of the exercise.

The scenario: Park Furnishings manufactures school and university classroom furniture

DEADLINE 48 HOURS

SHOW ALL THE WORKING STEP BY STEP PLEASE

ALSO POST THE ANSWERS ON THE SPACES PROVIDED BUT THE WORKING MUST BE PROVIDED IN A SEPARATE DCUMENT AS WELL AS THE SCETCHES

The scenario

You can check Chegg  for examples as i saw the they have completed the question but using different figures. But the work must be with no plagiarism and should be to the point

Park Furnishings manufactures school and university classroom furniture. The company has two production plants, located at Easton and Weston. The Easton plant produce tables and chairs and the Weston plant produces desks and computer workstations. Park has a working day of 7.5 hours and employs twenty workers at each plant. You may assume that there is a total of 24 working days every month.

All Park products are manufactured using finished pressed wood and polished aluminium fittings. Including scrap, each table and desk uses 20 m2 of pressed wood whereas each chair and workstation needs 12.5 m2 and 30 m2 respectively. A total of 240000 m2 of pressed wood is available each month and is divided equally between the two plants. The aluminium fittings that reinforce the legs of all the production items are purchased from an outside supplier. Each plant can purchase up to 9500 boxes of fittings per month and one box is required for every item of furniture produced. Production times are 72 minutes per table, 18 minutes per chair, 90 minutes per desk and 2 hours per workstation.

The unit profit for chairs and tables are £39 and £72 respectively, whereas each desk and workstation generates profits of £105 and £142 respectively.

Park is considering combining operations of both plants into a single factory. This consolidation will have the advantage of combining all available production resources as well as reducing administration costs by £1420 per month; however they have estimated that the cost of renovating and equipping the factory will be £1100000. Due to the current financial position Park Furnishings is only prepared to go ahead with the combined operation if it saves money in the first year of operation.

  

Let

· x1 represent the number of tables made per month;

· x2 represent the number of chairs made per month;

· x3 represent the number of desks made per month;

· x4 represent the number of workstations made per month;

where x1,x2,x3,x4 ≥0

  

(a) Easton

Enter the constraints for the Easton plant and the expression to be optimised.

Maximise:  x1 +  x2

subject to

x1 +  x2≤      [Wood]

x1 +  x2≤      [Metal fittings]

x1 +  x2≤     [Labour]

Sketch the constraints and hence find the values of

· (i) a,b,c, the intersections of the Wood, Metal Fittings and Labour constraint respectively with the x1-axis;

· (ii) d,e,f,the intersections of the Wood, Metal Fittings and Labour constraint respectively with the x2-axis;

Enter the values, to the nearest integer in the appropriate boxes below:

Enter a:
Enter b:
Enter c:
Enter d:
Enter e:
Enter f: 

Now draw a sample profit line on your graph. Choose a value of the profit (P>0) and using this value, find the values of

(i) g, the intersection of your sample profit line with the x1x1-axis;

(ii) h, the intersection of your sample profit line with the x2x2-axis;

Enter the values, to the nearest integer in the appropriate boxes below:

Enter P:
Enter g:
Enter h:

 

Determine the optimal solution for x1 and x2 to the nearest integer and the profit that this solution will generate and enter your solution below.

The optimal solution is x1=  ,     x2= 

Profit: £ 

Select the two constraints which intersect to give the optimal solution.

The optimal solution is the intersection of   Select Wood Metal Fittings Labour x1 ≥ 0 x2 ≥ 0  with   Select Wood Metal Fittings Labour x1 ≥ 0 x2 ≥ 0 

  

(b) Weston

Enter the constraints for the Weston plant and the expression to be optimised.

Maximise:  x3 +  x4

subject to

x3 +  x4≤      [Wood]

x3 +  x4≤      [Metal fittings]

x3 +  x4≤      [Labour]

Sketch the constraints and hence find the values of

· (i) a,b,c, the intersections of the Wood, Metal Fittings and Labour constraint respectively with the x3-axis;

· (ii) d,e,f, the intersections of the Wood, Metal Fittings and Labour constraint respectively with the x4-axis;

Enter the values, to the nearest integer in the appropriate boxes below:

Enter a:
Enter b:
Enter c:
Enter d:
Enter e:
Enter f: 

Now draw a sample profit line on your graph. Choose a value of the profit (P>0) and using this value, find the values of

· (i) g, the intersection of your sample profit line with the x3x3-axis;

· (ii) h, the intersection of your sample profit line with the x4x4-axis;

Enter the values, to the nearest integer in the appropriate boxes below:

Enter P:
Enter g:
Enter h:

 

Determine the optimal solution for x3 and x4 to the nearest integer and the profit that this solution will generate and enter your solution below.

The optimal solution is x3=  ,     x4= 

Profit: £ 

Select the two constraints which intersect to give the optimal solution.

The optimal solution is the intersection of   Select Wood Metal Fittings Labour x3 ≥ 0 x4 ≥ 0  with   Select Wood Metal Fittings Labour x3 ≥ 0 x4 ≥ 0 

  

(c) Combined

Enter the constraints for combining the plants and the expression to be optimised.

Maximise:  x1 +  x2 +  x3 +  x4

subject to

x1 +  x2+  x3 +  x4≤   [Wood]

x1 +  x2+  x3 +  x4≤  [Metal fittings]

x1 +  x2+  x3 +  x4≤  [Labour]

Determine the optimal solution for x1,x2,x3,and x4 and the profit that this solution will generate and enter your solution below. ( Enter the optimal solution correct to 3dp and the profit to the nearest pound.)

The optimal solution is x1=  ,     x2=  ,     x3=  ,     x4= 

Profit: £ 

Is it economically sensible to combine the two plants?   Select Yes No I do not know 

SOCW 6301 2 part Dis

  

Discussion 1: Methods of Measuring

The center point of research studies is the body of data collected to answer the research question. These data must be measured, which is the act of taking an abstract concept (e.g., depression, anger, etc.), sorting them out and quantifying them in some cohesive way in order to construct meaning—but how can you measure something that is not easily quantifiable?

Choosing an appropriate measurement tool requires consideration of a number of different issues including reliability, validity, appropriateness for use with a specific group or culture, availability, and potential cost. Sometimes, social workers will attempt to create their own set of questions to tap into or measure a concept. This may appear to be an easy thing to do; however, writing questions to measure a phenomenon is more challenging than it would seem. For example, how do we know it measures what we want it to measure? In the first discussion this week, you will have the opportunity to create your own questions to measure a phenomenon of your interest. In the second discussion, you will compare the measure you created with an existing instrument that measures the same phenomenon.

To prepare: Choose one phenomenon or issue that a client may be dealing with (for example, depression, anxiety, or family conflict). Consider how you would evaluate the client’s progress in this area. Create questions with response options that would capture this phenomenon or client issue.

By Day 3

Identify the phenomenon you would measure and explain how you conceptualize this phenomenon.

Provide at least 3 questions you would use to measure this phenomenon and explain how these questions operationalize the phenomenon.

Define reliability in 2-3 sentences and give one example of how you would establish reliability for the questions you created.

Define validity in 2-3 sentences and give one example of how you would establish validity for the questions you created.

Create a measurement plan to assess the phenomenon.

Describe the methodology you would use to collect data using your measurement tool (your method for acquiring this research data).

Explain the advantages and disadvantages of your choices.

Discussion 2: Evaluating Existing Measures

In discussion 1, you considered how you might create an instrument for measuring a phenomenon or client issue. For this week’s Discussion 2, choose and evaluate an existing instrument to measure the concept you identified in Discussion 1. Consider how you would compare your original measurement to the existing measurement.

To Prepare: Review the following at the Walden Library on how to find existing instruments:

http://academicguides.waldenu.edu/library/testsmeasures

By Day 5

Posta brief explanation of the existing measurement instrument that you identified. Then, compare your original measurement approach to the existing instrument. Next, explain how you would revise or replace your original measurement plan. Finally explain the advantages and/or disadvantages of using existing instruments for measurement. Please use the Learning Resources to support your answer.

Discussion 1: Best Practices in Interviewing

 

“Ordinary conversations are about sociability and maintaining a relationship, while interviews are more about making a relationship to help find an answer to a research question” (Rubin & Rubin, 2012, p. 99).

For this Discussion, you will view videos that depict different interviewing techniques. You will then analyze and evaluate the techniques used, and you will discuss how you will utilize best practices when you conduct your own interviews.

To prepare for this Discussion:

  • Review Chapter 12 of the Rubin and Rubin course text.
  • Review the two media segments on interviewing. As you view the videos, practice your observation skills by creating field notes for yourself. Be careful to distinguish between observation and interpretation as Dr. Crawford warns in the videos.
  • Consider the following questions for your post to evaluate the techniques used in each interview. Which practices could you use in your own interview? Which practices should you avoid? Where did the person in the video go wrong? How could this issue have been avoided or corrected?

ASSIGNMENT

 

Post a 2- to 3-paragraph evaluation of the interview techniques used in both interviews. Include commentary and analysis of best practices, practices to avoid, and how this viewing experience will inform your approach to the interviewing assignment introduced in this week’s Major Assignment.

When appropriate, be sure to support your postings and responses with specific references to the reading(s) and/or video program(s) and use APA format.

apa required

turn it in required 

 

Required Readings

Saldaña, J. (2016). The coding manual for qualitative researchers (3rd ed.). Thousand Oaks, CA: Sage Publications.
Chapter 1, “An Introduction to Codes and Coding” (pp. 1–42) (previously read in Weeks 5 and 6)
Chapter 2, “Writing Analytic Memos About Narrative and Visual Data” (pp. 43–65) (previously read in Weeks 5 and 6)

Ravitch, S. M., & Carl, N. M. (2016). Qualitative research: Bridging the conceptual, theoretical, and methodological. Thousand Oaks, CA: Sage Publications.
Chapter 5, “Methods of Data Collection” (pp. 145–183)
Chapter 7, “An Integrative Approach to Data Analysis” (pp. 215–236) (previously read in Weeks 5 and 6)
Chapter 8, “Methods and Processes of Data Analysis” (pp. 237–270) (previously read in Weeks 5 and 6)

Rubin, H. J., & Rubin, I. S. (2012). Qualitative interviewing: The art of hearing data (3rd ed.). Thousand Oaks, CA: Sage Publications.
Chapter 6, “Conversational Partnerships” (pp. 71–93)
Chapter 7, “The Responsive Interview as an Extended Conversation” (pp. 95–114)
Chapter 8, “Structure of the Responsive Interview” (pp. 115–129)
Chapter 9, “Designing Main Questions and Probes” (pp. 131–147)
Chapter 10, “Preparing Follow-Up Questions” (pp. 149–169)
Chapter 12, “Data Analysis in the Responsive Interviewing Model” (pp. 189–211) (previously read in Weeks 5 and 6)

Yob, I., & Brewer, P. (n.d.). Working toward the common good: An online university’s perspectives  on social change, 1-25.
 

M5A2

 

Personality Characteristics and Criminal Behavior

A particular set of personality characteristics does not  turn a person into a criminal. However, criminals may have the same set  of characteristics. This concept may not be easy to understand. Here is  another example: all college graduates have attended college, but not  everyone who attended college is a college graduate. The mistake that  “if A then B” is the same as “if B then A” is a common one in research,  criminal investigation, and profiling.

Criminal profiling is a difficult task. Complete the following three parts and present them in your report.

Part I

Identify at least five offense characteristics of each  of the following crimes: sex offense, murder, acquisitive crime,  organized crime, and terrorism.

Part II

Choose two offenses for those listed in Part I. Using the selected characteristics, complete the following for each of the two offenses you selected:

  • Analyze the selected characteristics to develop a forensic profile  for that particular type of offense. For example, how would you use the  two offense characteristics you have selected for murder to develop  inferences regarding the personality of a murderer?
  • Explain how an offender’s level of cognitive and emotional  functioning, as well as social and environmental factors, could  contribute to his or her maladaptive behavior in each of the above  offenses.
  • Identify and justify the types of tests and/or personality measures  that might be used to gather additional information for each of the two  offenses.
  • Identify and justify the type of collateral information you would  need to learn about the offender in the case of each of the two crimes.

Part III

  • Identify the differences between ethical standards in a criminal  investigation and ethical standards in a psychological interview.
  • Offer your recommendations for future research needed to advance the science and research of psychological profiling techniques.
  • Discuss the different ethical considerations one must follow as an investigator and as a psychologist.

Support your responses giving reasons and examples from eight to ten scholarly resources.

Write a 7- to 9-page report in a Microsoft Word document. Apply APA standards to cite sources.

Your paper should be written in a clear, concise, and  organized manner; demonstrate ethical scholarship in accurate  representation and attribution of sources; and display accurate  spelling, grammar, and punctuation.

conduct a comparative analysis of two publicly traded companies (pepsi & coca cola)

Assignment #1 

For this assignment, you need to conduct a comparative analysis of two publicly traded companies in the same industry regarding their operations strategy and resulting productivity measures (example of productivity measures for PepsiCo and Coca Cola are shown below).

Chart, line chart  Description automatically generatedChart, line chart  Description automatically generated

PepsiCo  Coca Cola

There are two sections to this report: 

Section 1:   

For each of the 5 productivity metrics, you will need to discuss how you think the differences in the two companies’ performances for that metric can be explained based on the differences in how they conduct their operations.  

Section 2:

Discuss which company you believe is in the better competitive position now as well as long term regarding their overall operations strategy. 

You will need to justify your statements being made for sections 1 and 2, so feel free to research the companies further and cite your references within your assignment submission. The paper is worth 10 points; 5 points for section 1 and 5 points for section 2. The grading will be based upon 2 components: content (you cover each point required above and provide logical justification to back up your statements) and Readability (it is easy to read and understand). There is no required length for this paper (maximum or minimum). 

Some groups may be able to get straight to the point with clear justification for their arguments using 2 or 3 pages of double spaced, 12-point font content, while others may need more.   

Nursing discussion board

 

Module 1 Discussion: HPMP

Review the HPMP Orientation HandbookPreview the document  and then substantively reply to the following question in 200 words or more: “Should nurses with substance abuse disorders be allowed to provide direct patient care?”  In your response, discuss how the ANA Code of Ethics for NursesPreview the document and the ICN Code of EthicsPreview the document applies to the situation. Be sure to review the Grading Rubric for important information.

Module 2:

 

Safety Assignment: 

  1. Isolation Precaution
    What is MRSA and how can it be spread from one patient to another? What precautions must the nurse take to prevent the spread of this organism?
  2. Team meeting
    Dena suggests that urinary catheters be removed as soon as possible. What is her rationale for this and why did the other nurses seem resistant to the idea?
  3. Infection Control Team
    How might the use of an inter-professional team work toward improved infection control in the hospital setting? Is there one in your professional setting?
  4. Patient Question about handwashing
    Consider how you will incorporate handwashing into your practice? Can you think of ways to reinforce this practice?
  5. Family member
    Communication with family is vital in nursing. How would you feel if you were the family member and were told that you needed to gown and glove every time you came to see your family member? How would you as the nurse reinforce to family the need to follow precaution policies?
  6. Dr. Greene
    Give three examples of how nurses can assist in the prevention of hospital-acquired infections? Consider what you have seen on the video, your readings and the lecture on infection prevention.

pin

 

Paul is a 12-year-old male diabetic. He maintains his personal digital assistant (PDA), hand-held device, that interfaces with his glucometer and provides information based on inputted data from him and his parents. This information is transmitted to his MD/hospital, school nurse, case manager (CM), and to the parents’ home computer. All in an attempt to better control his diabetes. You are his CM. 

The PDA sends an update to you since Paul’s blood glucose levels have been rising steadily for the last 5 days. The physician has left a message for you to contact this family and have them come in for an evaluation. You know that both of his parents work so you send an e-mail message to the parents via their home computer asking them to bring Paul in for an assessment. Since you are in a hurry and will be seeing other patients when they return from work, you decide to add more information to the message than normal reviewing with them the importance of maintaining control over the diabetes and expressing your concern since Paul has not checked in with you lately. You tell them that you think he might be over-doing it since he is trying to play football. You ask how they are doing and if they are still attending their counseling sessions.

Paul’s 4-year-old sister, Lilah, sends your email out to all of the diabetic lists that both Paul and his parents belong. They interact with people on these lists regularly. 

The parents are outraged that this information was sent everywhere. Imagine that you are the designated Privacy Officer in a healthcare institution.

Explain the following:

  • How would you feel in this situation?
  • What is the problem? (Clearly state the problem)
  • What ethical principles would guide you in this case?
  • What are the alternatives for solving this dilemma?
  • What are the consequences for each alternative generated?
  • In your opinion, what is the first choice from the alternatives and why?
  • Does your choice take into consideration all of the persons involved and the consequences to each of them?
  • If the worst case scenario would occur based on your choice, could you live with your decision?
  • Based on your choice, what is your plan of action?
  • What types of monitoring procedures would you develop?
  • What would you include in your sanctions for violations policy?
  • How would you address the following?
    • Tracking each point of access of the patient’s database including who entered the data
    • Nurses in your hospital have an access code that only gives them access to their Unit’s patients. A visitor accidentally comes to the wrong unit looking for a patient and asks the nurse to find out what unit the patient is on.

Write a reply for the post below with a minimum of 200 words

Do Bias Influence your Decision Making

Answers to the six questions

1.    The Answer should lie between 2,000and 100,000.

2.    F

3.    Yes; after investing 90 million, we might as well finish the project

4.    100,000

5.    7

6.    Alternative B; A sure gain of $500 and Alternative C; a 50 percent chance of losing $1,000

There is a considerable difference between the answers I provided and those provided by the book. From the answers I provided, it is clear that they were based on emotions as opposed to making decisions in a logical way. For instance, my figure of between 2,000 and 100,000 is very small compared to the book answer, which is roughly 800,000,000,000,000 times the distance between the earth and the Sun. My answer was based on the thinness of the sheet, not taking account of the effect of doubling such thinness 100 times. This is affirmed by the second answer, in which case I did not realize each of the figures was different from the others. 

One other thing I found interesting is the effect of earlier information while making a decision. If someone has prior knowledge of a situation, it is more likely that his or her decisions will be based on that knowledge. Known as the primacy effect, early information has a dramatic effect compared to information obtained later. Another fascinating thing that I learned is that people hate losing more than they enjoy winning. For this reason, people make decisions that will be of great benefit to them, not taking into account chances of increasing their odds (Daft, 2015). Apparently, human people and especially entrepreneurs are known to be rational, which means that they will make a decision that has more benefits and least consequences. While it is hard to admit, it is clear that I am not different from what the book describes. For instance, I regard to continue investing even after losing the 90 million it is true that most people will not see a problem is losing the remaining 10 million,

References

Daft, R. L. (2015). Organization Theory and Design. Boston: Cengage Learning.

educational

 

Look over Freire’s (1970,1993) Chapter 3 as he explores the realities of politics, power, and oppression when it comes to those able to access education.  We also encounter certain Freirean convictions including the purpose of education as freedom.  

In this chapter, Freire explores many significant key terms and at times, they are laden with much complexity and may require a bit more discussion in order to fathom their exact meanings.  

  • Expand upon one (1) term and address the following
  • Analyze what Freire means to say when he uses this term. What support does he offer to explain the term?
  • Evaluate the term’s connection to the idea of curriculum reform. 
  • Assess the strength and validity of this term relative to what Freire is trying to convey in this chapter. Explain whether or not you do agree with this choice of term. Why or why not

Submit a paper which is 2-3 pages in length, exclusive of the title and reference page. The paper should be double-spaced.  Cite at least 1 additional source in APA format.  The paper should be well-written using Times New Roman, 12-point font. Check all content for grammar, spelling and to be sure that you have properly cited all resources (in APA format) used.

 Purdue University’s Online Writing Lab (OWL) is a free website that provides excellent information and resources for understanding and using the APA format and style. The OWL website can be accessed here: http://owl.english.purdue.edu/owl/resource/560/01/

 Proofread your work to make sure your responses are clear and coherent. Please be mindful of the quality of work you compose and turn in at the graduate level.   Contact your instructor if you have any questions or concerns.