Archive for category: My Nursing Writer

Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.

Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can be used to document the following:

Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID)
Invoice (InvNumber, InvDate, EmpNumber, InvAmount, CustomerID)
InvoiceLine (InvLineNumber, InvNumber, ProductNumber, Quantity)
Product (ProductNumber, ProductDescription, ProductCost)
Department (DepartmentID, DepartmentDescription)
Job (JobID, JobDescription)
Customer (CustomerID, CustomerName, CustomerAddress, CustomerPhone)
Write a three to four (3-4) page paper in which you:

Create a data dictionary that includes the following:
A description of the content for each field
The data type of each field
The format the data will be stored as in the field
The range of value for the field
A label, as required, if the attribute is a primary key or foreign key
Note: An example is shown in Table 7.3 in chapter 7 of the textbook.

Imagine that you are asked to identify the number of days that exist between the first invoice and last invoice for each month and complete the following:
Construct a query that will show the number of days that exist between the first invoice and last invoice, for each month, for each employee, using the DATEDIFF function. Be sure to provide the SQL script that will carry out this function.
Construct a query to show the expected payment date if invoices are due within 30 days of transaction.
Construct a query that will show distinct area codes of the customers.
Create a plan of the necessary activities that would be required to implement a valid database design process by including the following:
Steps in the conceptual design stage
Steps in DBMS selection stage
Steps in logical design stage
Steps in physical design stage
Task details of each activity within each stage
Your assignment must follow these formatting requirements:

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:

Design a relational database so that it is at least in 3NF.
Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
Explain the key principles of data security and identify data security risk and violations in data management system design.
Use technology and information resources to research issues in the strategic implications and management of database systems.
Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.

---

 

. .

---

---

The post Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language. appeared first on My Nursing Writer.

Compile the data and analyze the responses to better illustrate where this person his or her family and friends are in relation to accepting the diagnosis in relation to the standard health or illness definitions.

Identify one person from the illness group you chose in Week 1. The person should not be a patient at the facility in which you work. You can use friends family members or coworkers. Do not use the persons name in the paper but only initials. Administer the questionnaire you created in Week 1 to that person. Compile the data and analyze the responses to better illustrate where this person his or her family and friends are in relation to accepting the diagnosis in relation to the standard health or illness definitions. The analysis should also include coping skills treatment and support aspects of the illness. Identify how this will direct care plan development for the chosen illness group.
Compile a report of your interview with the questions you created the responses you received your analysis and your interpretation of how it will affect planning care for the group in a 4 page Microsoft Word document.

---

 

. .

---

---

The post Compile the data and analyze the responses to better illustrate where this person his or her family and friends are in relation to accepting the diagnosis in relation to the standard health or illness definitions. appeared first on My Nursing Writer.

Post a description of the disorder and underlying respiratory alteration associated with the type of cough in your selected scenario.

Discussion: Respiratory Alterations
In clinical settings, patients often present with various respiratory symptoms such as congestion, coughing, and wheezing. While identifying a symptom’s underlying illness can be challenging, it is essential because even basic symptoms such as persistent coughing can be a sign of a more severe disorder. Advanced practice nurses must be able to differentiate between moderate and severe respiratory disorders, as well as properly diagnose and prescribe treatment for their patients. For this reason, you must have an understanding of the pathophysiology of respiratory disorders.

Consider the following three scenarios:

Scenario 1:

Ms. Teel brings in her 7-month-old infant for evaluation. She is afraid that the baby might have respiratory syncytial virus (RSV) because she seems to be coughing a lot, and Ms. Teel heard that RSV is a common condition for infants. A detailed patient history reveals that the infant has been coughing consistently for several months. It’s never seemed all that bad. Ms. Teel thought it was just a normal thing, but then she read about RSV. Closer evaluation indicates that the infant coughs mostly at night; and, in fact, most nights the baby coughs to some extent. Additionally, Ms. Teel confirms that the infant seems to cough more when she cries. Physical examination reveals an apparently healthy age- and weight-appropriate, 7-month-old infant with breath sounds that are clear to auscultation. The infant’s medical history is significant only for eczema that was actually quite bad a few months back. Otherwise, the only remarkable history is an allergic reaction to amoxicillin that she experienced 3 months ago when she had an ear infection.

Scenario 2:

Kevin is a 6-year-old boy who is brought in for evaluation by his parents. The parents are concerned that he has a really deep cough that he just can’t seem to get over. The history reveals that he was in his usual state of good health until approximately 1 week ago when he developed a profound cough. His parents say that it is deep and sounds like he is barking. He coughs so hard that sometimes he actually vomits. The cough is productive for mucus, but there is no blood in it. Kevin has had a low-grade temperature but nothing really high. His parents do not have a thermometer and don’t know for sure how high it got. His past medical history is negative. He has never had childhood asthma or RSV. His mother says that they moved around a lot in his first 2 years and she is not sure that his immunizations are up to date. She does not have a current vaccination record.

Scenario 3:

Maria is a 36-year-old who presents for evaluation of a cough. She is normally a healthy young lady with no significant medical history. She takes no medications and does not smoke. She reports that she was in her usual state of good health until approximately 3 weeks ago when she developed a “really bad cold.” The cold is characterized by a profound, deep, mucus-producing cough. She denies any rhinorrhea or rhinitis—the primary problem is the cough. She develops these coughing fits that are prolonged, very deep, and productive of a lot of green sputum. She hasn’t had any fever but does have a scratchy throat. Maria has tried over-the-counter cough medicines but has not had much relief. The cough keeps her awake at night and sometimes gets so bad that she gags and dry heaves.

---

 

. .

---

---

The post Post a description of the disorder and underlying respiratory alteration associated with the type of cough in your selected scenario. appeared first on My Nursing Writer.

Create an ethical code of conduct for those in governance, management, and professional staff for any one of these health care organizations:

Create an ethical code of conduct for those in governance, management, and professional staff for any one of these health care organizations:

Acute-care hospital

Surgery Center

Behavioral Health Center

Specialty Hospital

Long-Term-Care Facility

Out-Patient Center

In a 10 to- 12 page paper (excluding title and reference pages), discuss the following:

Brief background of the facility.

Organization structure of the facility and duties/ responsibilities of those in management and professional staff.

Two possible ethical dilemmas that may be encountered.

Ethical standards for those in governance, management, and professional staff.

Ways to implement the ethical code of conduct and ensure compliance.

Consequences if there is a violation of the code of ethics.

When writing your paper, use 3rd person. Follow APA guidelines. Use at least eight scholarly and/or peer-reviewed sources that were published within the past five years, a minimum of three of which must be from the Ashford Online Library. All sources must be cited according to APA style as outlined in the Ashford Writing Center.

Writing the Final Paper

The Final Paper:

Must be 10 to 12 double-spaced pages in length, and formatted according to APA style as outlined in the Ashford Writing Center.

Must include a title page with the following:

Title of paper

Student’s name

Course name and number

Instructor’s name

Date submitted

Must include an introductory paragraph with a succinct thesis statement.

Must address the topic of the paper with critical thought.

Must conclude with a restatement of the thesis and a conclusion paragraph.

Must use at least eight scholarly and/or peer-reviewed sources that were published within the past five years,

including a minimum of three from the Ashford Online Library.

Must document all sources in APA style, as outlined in the Ashford Writing Center.

Must include a separate reference page. References should be no more than 5 years old per APA formatting.

---

 

. .

---

---

The post Create an ethical code of conduct for those in governance, management, and professional staff for any one of these health care organizations: appeared first on My Nursing Writer.

Is the use of soap and water or alcohol-based rubs more effective in preventing nosocomial infections?An appropriate research design for this research question is quantitative research with an experimental design.
one answer to each discussion.

discussion 1

Review the following research questions.

Is the use of soap and water or alcohol-based rubs more effective in preventing nosocomial infections?

Identify an appropriate research design.

An appropriate research design for this research question is quantitative research with an experimental design.

Discuss the strengths and weaknesses of the design.

According to Roger Watson (2015), quantitative studies produce numbers that should be interpreted before conclusions may be drawn. This can be considered a strength for this design as numbers allows the researcher to draw conclusion easily. An area of weakness is the idea that the opportunity for error cannot be eliminated entirely. According to Watson (2015) “it is essential to store data carefully, once it has been entered into any package, since loss can jeopardize the study”.

Provide a rationale for the design you selected

This design allows the research to manipulate the independent variable in order to study the effect it has on the dependent variable. In this case, the researcher is able to identify the effect of soap and water on the prevention of nosocomial infections and the effect is alcohol-based rubs on the prevention if nosocomial infections. The number of occurrences will be compared to draw a conclusion

How effective are anti-depressive medications on anxiety and depression?

Identify an appropriate research design.

An appropriate research design for this research question is qualitative design.

Discuss the strengths and weaknesses of the design.

According to Leslie Gelling (2014), while utilizing qualitative research, nurses to understand health and illness experiences and offer ‘compassionate, person-centered care. This is considered to be a strength for this design. Gelling also stated that “a poorly worded question might lead the research in the wrong direction, wasting the researcher’s time and, more importantly, wasting the research participants’ time if the chosen methodology is unable to answer the question (Gelling, 2014). This is the weakness of this design.

Provide a rationale for the design you selected

Qualitative research is an approach to scientific inquiry that allows researchers to explore human experiences in personal and social contexts, and gain greater understanding of the factors influencing these experiences.

What is the difference in attitudes of male and female college students toward condoms?

---

 

. .

---

---

The post Is the use of soap and water or alcohol-based rubs more effective in preventing nosocomial infections?An appropriate research design for this research question is quantitative research with an experimental design. appeared first on My Nursing Writer.