Instructions: 

Read the following Case Study and Answer the questions that follow.

Mr. Munoz is a struggling young actor in Chicago who has battled alcoholism since approximately the age of 13 years.

“There was a lot of fighting in our house when I was growing up,” he says. “Entering my middle school years, it just got worse,” he says. Mr. Munoz’s parents had violent fights. Although they were both very supportive of him, he cannot remember when they ever really got along.

Still, Mr. Munoz was able to get through early adolescence as an honors student and starred on both the debate team and his school’s drama club. He even starred in an elaborate production of Shakespeare’s Richard III.

“In our school,” he says, “if you were a drama club kind of kid instead of an athlete, you really had to prove yourself to be a real man to avoid getting picked on. I did that by drinking. We had lots of ways to sneak booze into the places we met, and it was kind of exciting at first. You’re 15 years old, you’re outside on a starry night in a big city, you’re with your friends, and there’s plenty of alcohol. It makes you feel like a big man.”

Unfortunately, his parents never seemed to notice; therefore, Mr. Munoz never got help or encouragement to stop.

“After high school, my stress—and the reasons I gave myself for drinking—got worse. Those good grades got me partial scholarships to some local colleges—but mostly for drama awards, which suited me fine. But when my parents found out I wanted to be an actor, they freaked out.”

When Mr. Munoz refused to pursue prelaw, as his parents insisted, they withdrew all financial (and emotional) support, and they dissolved their marriage and household at the same time.

“It wasn’t all bad,” Mr. Munoz says. “I used the best partial scholarship, stayed local, living with friends, and we all went to school part time and worked part time—mostly in bars. The party just sort of—yeah—continued.”

Fourteen years later, Mr. Munoz is well known enough to “make a decent living” as an actor, teaching workshops on the side and waiting tables in the lean times. Half of his friends are now married and no longer trying to pursue acting.

“As the loneliness has increased, so has my drinking,” he says. “I mean, I have friends, but I never married, so those old days are just gone. I never made it to the New York stage as I’d dreamed, so all I have of those old party days is the alcohol. Only the alcohol has remained available. It tastes like nostalgia, you know?”

Because he started so young and because alcohol has played such a central role in his life, for the past 2 years, Mr. Munoz has already begun battling early stages of cirrhosis.

“I sort of didn’t expect this until old age,” he says with a sad smile. “Imagine my shock.”

He tells the nurse that he has not had a drink for 4 months.

1.      Mr. Munoz was initially treated with neomycin, followed by lactulose. “The lactulose has worked better for me,” he says, “but it has some side effects that aren’t any fun.” How should he be counseled nutritionally—taking into account both his condition and his drug therapy?

2.      Unfortunately, Mr. Munoz’s disorder progresses to end-stage liver disease, and he is awaiting a liver transplant. The good news is that he is an excellent candidate. What are likely his most crucial nutritional needs (a) at this time and (b) during the immediate posttransplant period?

 

Choose one of the topics below:

• Cardiovascular disease
• Sepsis
• Chronic obstructive pulmonary disease
• Burns
• Celiac disease

Develop a substantial initial post addressing all the points below:

• Provide a brief description of the pathophysiology of the disorder.
• Discuss the nutritional needs for a patient with this disorder.
• Choose the nutritional treatment or diet plan the nurse would implement for a patient with this disorder.

 Use evidence from one scholarly source other than your textbook or ATI book to support your answer. Use APA Style to cite your sources. 1 page.

  

Log onto http://sqlfiddle.com/ and execute the SQL commands listed in the order provided in this document. Reference the Provider Table below and use its information to build the database. Refer to the “Data Manipulation and Querying With SQL Resource” document for assistance in completing this assignment.

Copy and paste a screenshot of each executed command and the populated data onto a document and submit for grading.

Provider Table: 

ProviderID FirstName LastName HireDate

———- ———- ———- ———-

123456 Ben Spock

123457 Albert Schweitzer 1990-05-09

123458 Derek Shepherd 2005-03-27

123459 Mark Sloan 2005-03-27

 
 

1. Command      CREATE TABLE 
2. Command that      ALTER table by adding column 
3. Command      INSERT values for populating table 
4. Perform six      (6) queries to the Provider Table: 

a. Command SELECT from Provider Table querying Last Name, Hire Date 

b. Command SELECT from Provider Table querying Hire Date 

c. Command SELECT from Provider Table querying specific Provider by Last Name and First Name 

d. Command SELECT FROM Provider Table querying specific Provider by ID and Last Name 

e. Command SELECT FROM Provider Table querying Hire Dates 

f. Command SELECT FROM Provider Table querying Provider Hire Date is NULL 

1. Command ALTER      TABLE and UPDATE to add a new Salary column to the Provider table 
2. Perform three      (3) column function queries on the Provider Table: 

a. SELECT SUM 

b. SELECT AVG 

c. SELECT MIN, SELECT AVG, and SELECT MAX 

1. Perform three      (3) COUNT queries on the Provider table 

a. SELECT COUNT FROM Provider 

b. SELECT COUNT from HIRE DATE 

c. SELECT COUNT DISTINCT  

1. Command      INSERT INTO Provider table adding a new row  
2. Perform two      (2) aggregation queries on the Provider table 

a. SELECT HireDate from Provider table 

b. SELECT HireDate COUNT FROM PROVIDER GROUP BY HireDate HAVING COUNT (*)>1; 

1. CREATE      PATIENT TABLE with the data values provided in the assignment. 
2. Perform      query command SELECT FROM Patient table 
3. Perform      three (3) multi-table queries of PROVIDER and PATIENT tables 
4. Modify      the database by adding an additional column (“Deleted_Date”) to      a table. Justify your rationale in a short paragraph by explaining what      the tradeoffs are in using a marker-column for deletion, as opposed      to deleting a row from a table? 

Effective Communication

The Joint Commission reported that [poor] communication was the root cause of 66% of Sentinel Events between 1995-2005. Examine the communication and collaboration in your workplace. Include these aspects:

• The components necessary for effective interpersonal communication.
• Discuss the importance of interprofessional collaboration.
• Apply components of interpersonal communication to interprofessional collaboration.
• Discuss strategies to promote interprofessional collaboration.
• Describe effective strategies to build interprofessional teams.
• Cultural competence

Assignment Expectations:

Length: Between 1500 and 2000 words

Structure:  Include a title page and reference page in APA format. These do not  count towards the minimum word count for this assignment. Your essay  must include an introduction and a conclusion.

References:  Use appropriate APA style in-text citations and references for all  resources utilized to answer the questions. You should utilize at least  two scholarly sources in addition to your textbook.

Rubric:  This assignment uses a rubric for scoring. Please review it as part of  your assignment preparation and again prior to submission to ensure you  have addressed its criteria at the highest level.

Format: Save your assignment as a Microsoft Word document (.doc or .docx) 

 

Short Answer Questions

1. Define the following terms:
   1. Bilateral
   2. Hypoventilation
   3. Hemothorax
   4. Arrhythmias
2. What are the normal ranges for blood pH, PCO2, and bicarbonate? What is the normal urine pH?
3. Under normal conditions, what would be the PRIMARY mechanism that the body would use to reduce the amount of PCO2 in the blood?
4. Describe how high bicarbonate in the blood is related to the low pH in his urine.
5. Describe the function of the following electrolytes in the body.
   1. Potassium
   2. Sodium
   3. Calcium
   4. Magnesium

Assignment Expectations

Length: 750-1200 words

Structure: Include a title page and reference page in APA style. These do not count towards the minimal word amount for this assignment. Please include an introduction paragraph and a conclusion paragraph for the case study.

References: Use the appropriate APA style in-text citations and references for all resources utilized to answer the questions. Include at least two (2) scholarly sources to support your claims.