Assignment 4: Database Modeling and Normalization

please APA style and no plagiarism

 

Imagine  that you work for a consulting firm that offers information technology  and database services. Part of its core services is to optimize and  offer streamline solutions for efficiency. In this scenario, your firm  has been awarded a contract to implement a new personnel system for a  government agency. This government agency has requested an optimized  data repository for its system which will enable the management staff to  perform essential human resources (HR) duties along with the capability  to produce ad hoc reporting features for various departments. They look  forward to holding data that will allow them to perform HR core  functions such as hiring, promotions, policy enforcement, benefits  management, and training.

Using this scenario, write a three to four (3-4) page paper in which you:

  1. Determine  the steps in the development of an effective Entity Relationship Model  (ERM) Diagram and determine the possible iterative steps / factors that  one must consider in this process with consideration of the HR core  functions and responsibilities of the client.
  2. Analyze the risks that can occur if any of the developmental or iterative steps of creating an ERM Diagram are not performed.
  3. Select and rank at least five (5) entities that would be required for the development of the data repositories. 
  4. Specify the components that would be required to hold time-variant data for policy enforcement and training management. 
  5. Diagram  a possible 1:M solution that will hold salary history data, job  history, and training history for each employee through the use of  graphical tools. Note: The graphically depicted solution is not included in the required page length.
  6. Plan  each step of the normalization process to ensure the 3NF level of  normalization using the selected five (5) entities of the personnel  database solution. Document each step of the process and justify your  assumptions in the process.
  7. Diagram  at least five (5) possible entities that will be required to sustain a  personnel solution. The diagram should include the following:
    1. Dependency diagrams
    2. Multivalued dependencies

Note: The graphically depicted solution is not included in the required page length.

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.
  • Include  charts or diagrams created in a drawing tool with which you are  familiar. The completed diagrams / charts must be imported into the Word  document before the paper is submitted.

Human Resource Planning

Hello Team,

Human resource planning is the process of predicting the impending employment needs of an organization by creating action tactics that align with the staffing, recruiting, and employments strategies of an organization (Heneman, Judge, & Kammeyer, 2015).  These tactics serve as the foundation of staffing needs and considers internal and external influences.

For this assignment, you are tasked with the challenge of developing your Human Resources Plan for your organization or business that you would consider building or one that you have already built.  Feel free to use the textbook as a guide.

This paper will be included in your handbook that you are creating for your final.

In your paper, you will need to include the following concepts (the inclusion of the sub-titles are a requirement – shorten these any way you would like):

  1. Evaluating the relationship between the sub-processes of the organizational staffing process and relating them to the human resource management process.
  2. Comparing and contrasting the various approaches for determining the future human resource needs of an organization and constructing a human resource plan utilizing one of these approaches.
  3. Analyzing the selected type of workforce (why does this type of workforce or combination of workforce work better for your created organization) 
    • (i.e) core workforce,
    • flexible workforce,
    • outsourcing strategies 
  4. Comparing and contrasting the various means of job analysis
    • How would the job analysis process look?
    • How would you determine the development of job descriptions and job specifications that identify essential job functions and marginal job functions?

This paper should be at least 12-15 pages in length and should meet APA guidelines (double-spacing, title page, etc.). At least five online university library sources should be used in conjunction with the textbook (a total of six). Please note that the title page, the abstract page and reference page do not count towards the page count.

Assignment: Human Resource PlanningObjective: Human resource planning is the process of predicting the impending employment needs of an organization by creating action tactics that align with the staffing, recruiting, and employments strategies of an organization (Heneman, Judge, & Kammeyer, 2015).  These tactics serve as the foundation of staffing needs and considers internal and external influences.
For this assignment, you are tasked with the challenge of developing your Human Resources Plan for your organization or business that you would consider building or one that you have already built.  Feel free to use the textbook as a guide.
This paper will be included in your handbook that you are creating for your final.
In your paper, you will need to include the following concepts (the inclusion of the sub-titles are a requirement):
1. Organizational staffing process versus human resource management process.
• Evaluate the relationship between the organizational staffing process and the human resource management process.

2. Comparing and contrasting the various approaches for determining the future human resource needs of an organization and constructing a human resource plan utilizing one of these approaches.
3. Analyzing the selected type of workforce (why does this type of workforce or combination of workforce work better for your created organization)
•  (i.e) core workforce,
• flexible workforce,
• outsourcing strategies
4. Comparing and contrasting the various means of job analysis

• How would the job analysis process look?
• How would you determine the development of job descriptions and job specifications that identify essential job functions and marginal job functions?

This paper should be at least 12-15 pages in length and should meet APA guidelines (double-spacing, title page, etc.). At least five online university library sources should be used in conjunction with the textbook (a total of six).

Content and Development
16 Points PossiblePoints PossiblePoints EarnedCommentsPaper was at least 12 pages in length2  Introduction was inclusive of type of created company1  Created an effective HR plan2  Organizational staffing process and human resource management processes were described2  Determined the future human resource needs of a created organization2  Analyzed the selected type of workforce:
•  (i.e) core workforce,
• flexible workforce,
• outsourcing strategies2  Compared and contrasted the various means of job analysis2  Included thorough conclusion, which tied in with the elements addressed in paper1  Mechanics
6 Points PossiblePoints PossiblePoints EarnedCommentsPaper meets APA guidelines to include in-text  citations, double-spacing, title page and reference page2  Used textbook + five outside sources1  Rules of grammar, usage and punctuation are followed.2  Spelling is correct.1  Total Points200Submitted on Time?Date Due and Date Submitted:7/2/21 Yes! Full CreditAdjusted Points0Comments:

pathophysiology Module 06 Written Assignment – Diabetes Case Study Module 06 Content

 

Case Study:
A 21-year old female (A.M) presents to the urgent care clinic with symptoms of nausea, vomiting, diarrhea, and a fever for 3 days. She states that she has Type I diabetes and has not been managing her blood sugars since she’s been ill and unable to keep any food down. She’s only tolerated sips of water and juices. Since she’s also been unable to eat, she hasn’t taken any insulin as directed. While helping A.M. from the lobby to the examining room you note that she’s unsteady, note that her skin in warm and flushed and that she’s drowsy. You also note that she’s breathing rapidly and smell a slight sweet/fruity odor. A.M. has a challenge answering questions but keeps asking for water to drink.
You get more information from A.M. and learn

  • She had some readings on her glucometer which were reading ‘high’
  • She vomits almost every time she takes in fluid
  • She hasn’t voided for a day but voided a great deal the day before
  • She’s been sleeping long hours and finally woke up this morning and decided to seek care
  • Current labs and vital signs

chart information         Vita signs 

Blood pressure           88/46 mmHg

Heart rate                   132 bpm

Respiratory rate          36/min deep 

Temperature               101.3 F 

Additional data        Lab results 

Glucose                  657mg/dl

Potassium           6.2 mEq/L 

  •  
    Instructions:
  • Summarize the questions above and formulate what may be happening with A.M. and how you would improve her condition.
  •  Be sure to cite your sources in-text and on a References page using APA format. 

Discussion: Trial of T Hall

read the paper found here regarding the Trial of T. Hall.  From the paper, begin your reading on page 14 with the first full paragraph and end the reading after the completion of the first paragraph on page 17.  Once all reading is complete, respond to the following items:

  • Why was T. Hall singled out for scrutiny?
  • How did T. Hall’s neighbors respond to the gossip that this person’s sex was unclear?
  • What authority did women claim in assessing the situation?
  • What authority did men claim?
  • What does the struggle to mark T. Hall’s gender identity suggest about the structure of community life and the roles of men and women in colonial America?

You are required to submit an initial posting that addresses the items above. You are also expected to respond to the posting of at least one other student. Your response should address why you agree/disagree with their posting.

Minimum word counts for this assignment are as follows:  Initial Post = 200 words; Peer Response = 100 words.  These are minimum word counts–you can write more.  Be aware that only your answers count to the word counts (retyping questions into your post does not count toward the word count).

Be sure that you fully address the questions, providing detailed analysis and historical context.  Do not cut-and-paste from sources, but instead use your own words to answer in both the initial post and peer response.

Dr. Howell

 

5 PEER RESPONSES DUE IN 6 HOURS

5 RESPONSES DUE IN 6 HOURS

       

respond to at least two classmates

KELVIN’S POST:

An incompetent leader would not be able to trust an employee because they think that the employee is less competent than themselves. This would lead to a violation of trust. Ethical leaders have to put their trust in their employees. If trust is not established or broken, the leader is therefore unethical. Unethical leadership refers to leader behaviors or actions that are illegal or violate existing moral standards. The moral standards of trusting one another would be violated by an incompetent leader. Also, incompetent leaders tend to be arrogant or pridefully overconfident. This can lead to “classing heads” with employees in the work environment.

EDWIN’S POST:

Incompetent means to lack the training or skills to accomplish a task or to do something in particular with success. If a leader is incompetent, I believe it would be difficult for them to understand how to lead ethically. This may vary depending on the situation. If someone in a leadership position is lacking what they need to be successful it may not mean they will automatically make unethical decisions. For example, if I were to get a job as a manager at a welding company, in which I have zero experience, I would still attempt to run things as best as possible. My skills as a leader would still help me make decent decisions when it comes to things that involve the employees and that side of my job. Although, I may not understand the welding part, I would still understand certain things like, we should not cut corners on a project, we should follow all policies and procedures, and that we should perform jobs safely. This is a question that can be determined by a lot of variables so I would say yes, it is possible for an incompetent leader to still be ethical depending on what the leader is incompetent about and the circumstances. Now, if the leader was just incompetent about everything and simply unaware of their ignorance for some reason, that may be a bigger issue and that can cause them to act in an unethical manner. 

respond to at least two classmates

RUSSELL’S POST

This is the first discussion question that I feel the book answers straightforwardly.  There are empirical positives and negatives to working within and being a part of a group that the book does an excellent job of laying out.  However, I was a little alarmed at how many of the traits of group work were negative.  Groupthink, illusion of invulnerability, inherent morality, rationalization, out-groups and in-groups (several of the negatives concerned this), pressuring dissenters, poly think, intragroup conflict, leaks, confusion, framing information, lowest common denominator, decision paralysis, limited review, non-reappraisal of dismissed option, mismanaged agreement, escalating commitment, excessive control, moral exclusion, and a few others I may have glossed over.  The main point is that groups have the potential to accomplish much more than the individual, but at what cost?  Oftentimes that cost is the mental, spiritual and emotional well-being of the members.  Sometimes the members themselves are sacrificed (dismissed from the group or fired altogether) as a scapegoat.  At a minimum, most group members will feel a frustration with some aspect of the work they have accomplished.  We all want to feel like we were not just a part of the event, but the lynchpin.  “They couldn’t have done this without me suggesting that.”  That ego is natural and healthy for the submission of innovative ideas, but it can overtake you if you focus too long.  

On the other hand, I can say that when a successful meeting has finished or a project has been completed that I was a part of a group effort, you do feel a different kind of pride in the accomplishment.  You head to your car at the end of the day a little lighter when there were no arguments or you managed to contribute something significant to the proceedings.  That is a good feeling, and it keeps people coming back.  Leaders should maximize these opportunities whenever possible.

BRITTANY’S POST:

I believe groups bring out the best in us overall because from what I’ve seen in my life, working in a group setting forces us to be accountable for our actions and our words. We can’t shirk our responsibilities even a bit because there are other witnesses right there with us. That’s not a bad thing whatsoever – if the entire group holds each other accountable, the quality of the product or content being produced by the group can be expected to be greater than it could be otherwise.

Groups can also bring out the worst in us, definitely. Some people tend to be a bit controlling when it comes to different projects if they’re over-excited; conversely, it can also give other people an out in order to be a bit laxer with the quality of their own contributions to the project itself.

Then, respond/reply to at least one other student  (the best response/reply will have at least two (2) paragraphs with at least five (5) sentences each).

ROLANDA’S POST:

My scores suggest that I am strong in all four components of the assessment. I agree with it because the way my mother raised me it’s hard for me to not carry myself a certain way. We were brought up in the church (every Sunday, Wednesday and Saturday night) we played sports for the church team and when my mom was work she would have the church bus come pick us up. My internalized moral perspective was the highest score. The book defined that one as “self-regulatory process whereby individuals use their internal moral standards and values to guide their behavior rather than allow outside pressures to control them” (pg. 204).
 

On the SLQ assessment I scored high in the emotional healing, conceptual skills, putting followers 1st, and behaving ethically. I scored moderate in creating value for the community, empowering, and helping followers grow and succeed. I believe that the results support my view of myself because I’m not in a leadership role as of now so I don’t see myself as being able to push people to grow or empower them. I do support them in their choices and root for them to finish especially close friends. The ones I scored high on are parts of my character that’s just the type of person I am. 

I believe my best fit is the Authentic Leadership. 

Un10THass

 

You have examined the need for both an internal evaluation and an external evaluation of an event to ensure that the client receives feedback and the event planner can improve events going forward. Read the scenario, address the checklist items, and then respond according to the submission requirements for this assignment.

Scenario: The Fasure Company had a major business conference to reinvent themselves in the face of fierce competition and try to get some ideas for new products and new ways of approaching their business in the home-building products sector. The company wanted to incorporate sustainable practices in the 4-day conference as well. It took 9 months for the contracted event planner to plan the event. There were 200 invitees, consisting of executives, engineers, and supervisors, with three famous speakers on the agenda, and a budget of $800,000. The conference was held in August.

Access what the conference included.

Access the participant feedback from the conference evaluations.

Budget:

The Fasure Company had set aside $800,000 for the conference, not including airfares, incidentals, and reimbursed meals. The final costs came to a total of $740,000 before paying a salary of $35,000 for an assistant event planner or any profit for the planner.

Checklist:

  • Complete an evaluation of this event for (1) the event planner’s benefit (1 page of 250 words) and (2) the client’s benefit (1 page of 250 words).

Specify the following in each evaluation:

  • Include an overview of the event, the goals, the intended audience, the event schedule, and budget for the overall event.
  • Summarize the type of assessment instrument used per your textbook and the results of the feedback as well as other pertinent criteria, and provide your overall evaluation.
  • Then explain whether the event was on the whole successful or not and what recommendations you have to improve this event in the future. Be specific.

Submission Requirements:

Your response should consist of 2 pages minimum; a 1-page evaluation for internal purposes (i.e., the event planner’s evaluation) and a 1-page evaluation for the external organization or client.

Make sure that your evaluations are logical, based on the analysis of the provided results, and constitute a comprehensive depiction of the results. Use correct Standard English spelling and grammar.

Ensure that each evaluation has an opening paragraph and a closing paragraph, and that each paragraph is a minimum of 3 sentences.

Additionally, make sure that your evaluation response:

-Is written in Standard English with correct grammar, style, and mechanics.

-Has a purpose clearly stated in your introduction statement.

-Demonstrates logical and appropriate transitions from one idea to another. 

-Your evaluation should be highly organized, logical, and focused.

-Include additional title and reference pages in APA format and citation style

answer the questions

Q1. American​ Exploration, Inc., a natural gas​ producer, is trying to decide whether to revise its target capital structure. Currently it targets a 50​-50 mix of debt and​ equity, but it is considering a target capital structure with 70​% debt. American Exploration currently has 6​% after-tax cost of debt and a 12​% cost of common stock. The company does not have any preferred stock outstanding. 

a.  What is American​ Exploration’s current​ WACC?

b.  Assuming that its cost of debt and equity remain​ unchanged, what will be American Exploration’s WACC under the revised target capital​ structure?

c.  Do you think shareholders are affected by the increase in debt to 70​%? If​ so, how are they​ affected? Are the common stock claims riskier​ now? 

d.  Suppose that in response to the increase in​ debt, American​ Exploration’s shareholders increase their required return so that cost of common equity is 16​%. What will its new WACC be in this​ case?

Q2. What is the significance of voting rights to the ordinary shareholders? What is a proxy? Why do proxy fights occur?

Q3. Briefly explain the factors that influence the planning of the capital structure in practice.

Q4. ‘Bonus shares represent simply a division of corporate pie into a large number of pieces.’ Explain.

Homeland security homework 3

Introduction

Within the Department of Defense, the military’s role is the defense of the U.S. against foreign threats; the Department of the Army, the Department of the Navy, and the Department of the Air Force fall under this responsibility. At the state level, there are National Guard and Air National Guard units. The Guard operates on a dual basis, serving the country in the defense against foreign threats, and responding to state emergency service during a domestic emergency. Guard units can be called upon for multiple reasons, to include domestic threats and to aid in the event of a natural disaster. Whereas the U.S. military is limited under legislative act. In this activity you will explore the role the military has within homeland defense at the federal and state level, and you will explain what the Posse Comitatus Act is, and how it affects the military within homeland security.

Activity Instructions

talk about the role of the military within homeland defense at the federal and state level. Then, explain what the Posse Comitatus Act is, and how it affects the role of the military within homeland security. Be sure to reference Chapters 5 and 7 of your textbook, as well as online resources.

500 CHTRS

Module 4 520 Discussion-Access to Affordable Care and Organizational Policy

ASSIGNMENT

What is the responsibility of health care administrators to work towards, as part of their organizational policy, access to affordable care? How does this relate to community benefit spending?

Cite reliable sources in your discussion posts.

Required Reading

American College of Healthcare Executives. (2016) Access to affordable healthcare. Retrieved from https://www.ache.org/about-ache/our-story/our-commitments/policy-statements/access-to-affordable-healthcare

Chaiyachati, K. H., Qi, M., & Werner, R. M. (2018) Non-profit hospital community benefit spending based on local sociodemographics. Journal of Healthcare for the Poor and Underserved, 29, 1259-1268. Available in the Trident Online Library.

Clary, A. (2018, May 8) States work to hold hospitals accountable for community benefits spending. National Academy for State Health Policy. Retrieved from https://nashp.org/states-work-to-hold-hospitals-accountable-for-community-benefits-spending/

Cox, K. & Westbrook, D.H. (2017) Hospital leadership recognizes need to create partnerships to treat consequences of poverty. Current Problems in Adolescent Health Care, 47, 229-232. Available in the Trident Online Library.

Cronin, C. (2017) The prevalence of community benefit participation in the hospital region and its relationship to community health outcomes. Journal of Health and Human Services Administration, 40(1), 98-124. Available in the Trident Online Library.

Folkemer, D. C., Spicer, L. A., Mueller, C. H., Somerville, M. H., Brow, A.L.R., Milligan, C.J., & Boddie-Willis, C.L. (2011) Hospital community benefits after the ACA: The emerging federal framework. The Hilltop Institute. Retrieved from https://hilltopinstitute.org/wp-content/uploads/publications/HospitalCommunityBenefitsAfteTheACA-TheEmergingFederalFramework-Summary.pdf

James, J. (2016, February 25). Health policy brief: Nonprofit hospitals’ Community Benefit requirements. Under the Affordable Care Act, many nonprofit hospitals must meet new requirements to retain their tax-exempt status. Health Affairs. Retrieved from https://www.healthaffairs.org/do/10.1377/hpb20160225.954803/full/healthpolicybrief_153.pdf

Matthew, D. B. (2018) Next steps in health reform: Hospitals, Medicaid expansion, and racial equity. Journal of Law, Medicine, & Ethics, 46, 906-912. Available in the Trident Online Library.

Olive, M. (2015, October 12) Surrounded by poverty, urban hospitals reach out. Pew Charitable Trust. Retrieved from https://www.pewtrusts.org/en/research-and-analysis/blogs/stateline/2015/10/12/surrounded-by-poverty-urban-hospitals-reach-out

RTI (n.d.) Community benefit insight, Retrieved from http://www.communitybenefitinsight.org/

Singh, S., Young, G., Lee, S. D., Song, P. H. & Alexander, J. A. (2018) Analysis of hospital community benefit expenditures’ alignment with community health needs: Evidence from a national investigation of tax-exempt hospitals. American Journal of Public Health, 105(5) 914-921. Available in the Trident Online Library.

NSG week 2 project

 

Instructions

Week 2 Project

This assignment will help you understand your personality type. Through this assignment, you will analyze how your specific personality type can enhance or hinder effective leadership in the health care environment.

Using the South University Online Library or the Internet, research about personality types.

Note: You can use the following link to access the online assessment: Jung Typology Test

Based on your research and understanding, write a 3- to 4-page Microsoft Word document that:

  • Integrates how your specific personality type can enhance or hinder effective leadership in the health care environment.
  • Explains all four aspects of your personality gleaned from the assessment.
  • Includes 2- to 3-journal article references.

On a separate references page, cite all sources using APA format. Helpful APA guides and resources are available in the South University Online Library. Below are guides that are located in the library and can be accessed and downloaded via the South University Online Citation Resources: APA Style page. The American Psychological Association website also provides detailed guidance on formatting, citations, and references at APA Style.
• APA Citation Helper
• APA Citations Quick Sheet
• APA-Style Formatting Guidelines for a Written Essay
• Basic Essay Template

Please note that the title and reference pages should not be included in the total page count of your paper.

Submission Details