Database Modeling and Normalization

Assignment 4: Database Modeling and Normalization

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:

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. Analyze the risks that can occur if any of the developmental or iterative steps of creating an ERM Diagram are not performed. Select and rank at least five (5) entities that would be required for the development of the data repositories. Specify the components that would be required to hold time-variant data for policy enforcement and training management. 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 in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length. 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. Diagram at least five (5) possible entities that will be required to sustain a personnel solution. The diagram should include the following: Dependency diagrams Multivalued dependencies

Health Policy & Management

Core Policy Analysis

For this Application, which you will begin this week and complete by the end of next week, you are asked to analyze a core policy about health or healthcare. Examples might include policies on scope of practice for healthcare practitioners or on health insurance for children. After selecting your policy, locate resources to help you understand the specifics of it, including how its programs are organized and financed, how the services are delivered, and, generally, how well the policy has been implemented to date.

Make sure to select a policy on which you can focus in some detail. If you choose to analyze the policy on insurance for poor children, for example, you will soon discover that this policy differs from state to state, so you might wish to focus primarily on your state’s policy. Search databases to find an article explaining the background on this policy?the journal Health Affairs, for example, frequently publishes summaries on initiatives in child health insurance.

In addition, learn about the pros and cons of this policy by locating opinion statements issued by state or national organizations, such as the American Hospital Association (AHA) or American Medical Association (AMA). Many of these organizations have Web sites in which they not only explain their perspective or opinion on a policy but also have legislative sections with commentary on policy proposals currently under consideration in government.

To analyze this core policy, it is important that you gather this breadth of information. In your paper, you must cite the following:

*
At least two articles, Web sites, or other credible and neutral sources providing analysis of this core policy; at least one of these sources must be a peer-reviewed article.
*
At least two opinion statements from stakeholders regarding the policy. To find these, consider who the stakeholders would be. AMA, for example, has an important stake in whether or not children are covered by insurance or not, and would be a good source for such a statement. Look also for opinion papers from other professional or special-interest organizations. These might be on Web sites or in journals. At least one of these statements should be from a stakeholder Web site.

After reviewing these materials, write a two to three page paper in which you address the following:

1.
Summarize the policy and its main goals. Describe its implications on organization, financing, and delivery of healthcare services in the U.S.
2.
Discuss why you think this policy was introduced and any challenges it has faced. For example, has it faced major challenges in being funded or implemented?
3.
Summarize the opinions you have read. Based on this and your own understanding of the issue, do you think the policy needs to be changed significantly in order to meet its goals?
4.
Include an APA bibliography (in addition to the body of the two to three page paper), with a minimum of the four references, as described above.

Essay on the book "Heat of Darkness" by Joseph Conrad (English literature)

You are in a special warrants unit in a major metropolitan area that specifically goes after street crime suspects with violent tendencies and histories of resisting arrest by the police. You are new to the unit but have come from a very professionally run narcotics operation in which your previous team dealt with extremely violent offenders. The unit is made up of plainclothes patrol officers who carry silver badges and seasoned violent crimes detectives who carry gold badges. The badges are mounted in the outside of the police ID wallet and flip open when swung with the hand.

After about 3 weeks with the unit, you notice that everyone arrested by the unit has a welt on their forehead. You are tasked with taking a prisoner to the jail cell, and you get a close look at the welt, which reflects an obverse seal from the silver badge of the attached patrol personnel. When depositing the prisoner into the holding cell, you see another suspect who had been arrested earlier. He bears the welt reflecting the obverse seal of the gold badges of the detectives. You ask the prisoner you are placing in the cell how he got the welt, and he tells you that after he was handcuffed, one of the officers smacked him in the head with his badge and simply said, “Silver.” Upon returning to the office, you ask the supervisor about the welts on the prisoners. He laughs and says it is a competition between the silver badges and gold. Whichever group marks the most prisoners with their badge seal does not have to pay for any drinks at the off-duty party at the end of the month.

Note: This scenario is based on an actual antic of a narcotics unit operating in the late 1970s.

Please include answers in your main posting for the following questions. You must provide meaningful feedback to the main postings of at least 2 of your classmates.

Assignment Guidelines

  • In 4–6 paragraphs, address the following:
    • Is this behavior in any way acceptable in a law enforcement agency? Why or why not? Explain.
    • Why might these officers be engaging in this type of activity? Explain in detail.
    • Regarding this activities use as a coping strategy, what do you think are at least 2 potential negative outcomes of this behavior? Explain.
    • Disclose your feelings about this activity from a moral and legal standpoint.
    • How do you think these officers could be approached through proper negotiation to successfully moderate their interpersonal discord? Explain in detail.
  • Post a new topic to the Discussion Board that contains your responses to the above questions.
  • Comment on at least 2 other students’ posts.

In your own words, please post a response to the Discussion Board and comment on at least two other postings. You will be graded on the quality of your postings.

For assistance with your assignment, please use your text, Web resources, and all course materials.

What Makes Art so Valuable to Steal?

To quote the FBI Art Crime Team website, “Art and cultural property crime- which includes theft, fraud, looting, and trafficking across state and international lines- is a looming criminal enterprise with estimated losses running as high as $6 billion annually.” In 1990, paintings and other items were stolen from the Isabella Steward Gardner Museum in Boston, Massachusetts, and valued at over $500 million. They were never recovered. Your job in this assignment is to be a detective reporter for the New York Times and gain an exclusive interview with one of the following:

  • owner of a stolen art piece or
  • curator of the museum where a work of art was stolen

First Paragraph: You are not limited to the Isabella Steward Gardner Museum crime scene and may choose an art work from any of the crime scenes found in the web sites you are linked to below. When formatting your post to the Advanced Forum, include one paragraph that describes the crime scene you have chosen to study. Include the name of the stolen work, the players in the heist, such as the criminals and the museum curators, directors, detectives names. Include historical details such as the time, place and title of the stolen work, the date the work was made and the artist. .

Second Paragraph: Consider the many reasons why the work stolen is valued by a certain segment of society, other than the obvious financial one, and include those considerations in a second paragraph. Explain the New York Times interest in covering this story, since you are the reporter.

Third:  Tell us to whom you are asking your questions. Then ask your three questions. Respond to all ask of you and in at least 150 words

 

Provide a real life example of classical conditioning from your life experience.

Provide a real life example of classical conditioning from your life experience. Be sure to label the different components of classical conditioning in your example, namely:

Neutral Stimulus (NS)
Unconditioned Stimulus (UCS)
Unconditioned Response (UCR)
Conditioned Stimulus (CS)
Conditioned Response (CR)
Feel free to use TV commercials, music, fears or phobias, or other real world illustrations in your answer.

Here is an example post to help you get started:

“When I was a kid growing up in NY, my grandma lived in Queens in a two story brick semi-attached house near the park. Whenever I went to visit Grandma, she would always have the heat cranked up really high. As you might imagine, every time I went to visit her, I would sweat profusely. Eventually, over time, I would break out into a sweat before I even went inside Grandma’s house. I would just see her house, and start to sweat. This effect can be explained by classical conditioning, or the repeated pairing of one stimulus (the house) with another (the heat). In this example, Grandma’s house before conditioning or repeated pairing with the heat is the neutral stimulus (NS). The heat is the unconditioned stimulus (UCS) because it causes a response or reaction that did not have to be learned. It is innate or a reflex. Sweating in reaction to the heat is the unconditioned response (UCR). Again, this is an unconditioned response because your body does it automatically, without any thought. It is automatic. After repeated pairings, conditioning or learning takes place, and the neutral stimulus (NS) alone causes the sweating to occur. When the neutral stimulus (house) takes on the properties of the unconditioned stimulus (heat), conditioning or learning has taken place. In this example, Grandma’s house becomes the conditioned stimulus (CS), and sweating in reaction to just Grandma’s house (nothing else) is the conditioned response (CR).

Bringing Team Together, Apprising Them and Mapping out a Timeline with Deliverables – Success University Scenario

Success University (SU) is a medium sized undergraduate institution located in Southern California.  SU offers Associates and Bachelors programs in Business, Psychology and Education at their San Moreno campus and online. SU has decided to launch three new programs next Fall.

The three programs to be launched are:

  1. A  Business Certificate in Leadership
  2. An Associates of Science  (AS) degree in Business Administration
  3. A Bachelor’s of Science degree in Business Administration (BSBA) with a concentration in Organizational Leadership

The accrediting body of Success University has given the programs their blessing and the School of Business has been charged with launching the three programs.  They have created a team consisting of faculty, graduates, admissions staff, student services personnel and a marketing representative from the Corporate Office to assist in the launch of the programs.

You are tasked with bringing the team together, apprising them of their roles and responsibilities within the team and mapping out a timeline with deliverables.

You are to produce an executive brief of a 5 – 7 pages that clearly outlines the:

  1. Team plan: Your plan to create a cohesive team. Include at least three strategies you plan to use to ensure a unified team.
  2. Launch plan – a comprehensive list of steps (at least 6) describing how you will launch the new programs.
  3. Goals and Deliverables: Describe the goals you have set for this project and create a timeline with clearly marked deliverables.
  4. Evaluation and Monitoring: Explain how you plan to evaluate the progress of your team and individual team members – discuss the key strategies you will adopt to monitor your team’s progress and coach them to success. Examples might include weekly face to face meetings or written reports submitted to you weekly by each team member.
  5. Implementation plan: How do you intend to implement the launch plan? Discuss how the team will function and their roles during the implementation.
  6. Change plan: Create a strategy to deal with potential resistance from all stakeholders involved in the running and delivery of the new programs.  For example there may be a concern in terms of increased workload, having to learn new policies and processes and the speed of the planned changes.

Development of a Healthcare Business Unit’s Strategy

HCM401 Assignment 1: LASA 2 Instructions

Identify a health care organization for which a significant amount of information is available, in books, journals, reports, or on the Internet. Conduct an audit of the organization’s strategic assets based on the information you are able to gather from various sources. The audit you conduct will not be as thorough and detailed of an audit as the organization itself might conduct as you will not have access to the same inside information as internal auditors. Do your best to gather and report the following information.

  • Start with a general description of the service that the healthcare organization provides.  Include the mission statement for the organization.  If there is not one, create one you believe would best describe the mission of the organization.
    • The first part of your audit should address the organization’s historical financial performance and its current financial condition, as described in your textbook. A lot of the necessary data can be found in the organization’s annual report and its filings with the Securities and Exchange Commission (SEC) and state-level government regulatory agencies. Research sources such as business journals, magazines, and other media that report on these types of organizations.
  • The second part of the audit should describe in as much detail as possible what you consider to be the major resources and competencies of the organization.  Use a SWOT chart to categorize the most relevant points (these may be more narrative than quantitatively analytical). Try to identify assets that appear to be unique to the organization and that give it some competitive advantage over its rivals. Also make a note of areas in which the organization is weak, which might be the target of strategic attacks by those rivals.
    • Now consider the activities that are described in the value chain for this organization.  Which do you believe cost the most to perform?  What factors do you base your opinion on? What do you believe can be done to reduce the costs, thereby giving this organization a competitive edge?
  • Finally, consider that this organization would like to set up a satellite office in a nearby city.  In this satellite office they will make changes to their processes to address their strengths, weaknesses, opportunities and threats.  Develop a mission statement for this satellite office.  Create four strategic goals for this office, one for each SWOT category.

Application: Effects of Legislation on HR Outsourcing

Application: Effects of Legislation on HR Outsourcing

The stated goal of the Patient Protection and Affordable Care Act (PPACA) is to give more Americans access to health care. But relative to the topic of outsourcing, it may also be causing an increase in benefits administration outsourcing, as employers, especially those that are smaller, seek help in navigating the uncertain, complicated, ongoing health care-reform measures.

When facing the massive reporting and compliance requirements required by the new health care laws, many smaller and mid-size employers will seek more outside assistance/partnering. Many of them lack the back-office support to meet the PPACA’s regulations and it is not a skill they want to make a core competency (Starner, 2011).

Using the 5C model (culture, costs, competencies, compliance, competitors), analyze how new laws would specifically stimulate increased outsourcing of health care and related benefits. Consider examples at the local, state, and federal level of changes in laws/regulations that either increased or decreased business partnering and outsourcing. For example, why would a federal requirement for universal health care coverage increase HR outsourcing?

To complete this Assignment, respond to the following in a 3- to 4-page paper:

Analyze the effects of legislation on HR outsourcing.
Using the 5C model, analyze how new laws requiring universal health care would specifically stimulate increased outsourcing of health care and related benefits.
Using the table provided in this week’s Learning Resources (Effects of Legislation on HR Outsourcing), do research to fill in five of the nine cells illustrating the effects of local, state, and federal legislation on HR outsourcing.
Provide a brief description/explanation of each.
Identify whether the legislation increased, decreased, or had no effect on HR outsourcing.
Evaluate the effects of federal legislation requiring universal health care coverage on the outsourcing of health care in the U.S.
From your research, describe three specific effects you think such legislation would have on outsourcing of health care.
What specific actions can HR professionals take to enable employees to navigate the complexities of PPACA?

Reference:
Starner, T. (2011). Outsourcing health benefits grows more popular. Human Resources Executive Online. Retrieved from http://www.hreonline.com/HRE/story.jsp?storyId=533342142

Also note need at least 5-6 references

Stress Management Assignment

You are the senior veteran partner of a special highway patrol unit that is working a major interstate that is a corridor for drug and gun smuggling. Your partner has the highest marks ever in the academy and has a great civilian education in criminology. He knows the laws and regulations by heart. He is a staunch family man who is faithful to his wife, and except for an occasional beer with the boy, does not abuse alcohol. He has an exemplary work record and is extremely reliable. As such, he is assigned as your partner in a very hazardous detail of drug and gun intervention.

The job requires the officers to make legitimate profiling assessments of potential smugglers and wait for them to make a motor vehicle violation so that they can be stopped. Once stopped, minimal interview techniques almost always lead to the discovery of contraband and a subsequent arrest.

The first 3 months on the job with your new partner have been great. The two of you have made 18 felony arrests for narcotics and gun possession. Six of the drug arrests were major weights of crack and heroin. Two of the gun arrests involved the seizure of numerous fully automatic weapons.

In the beginning 2 weeks of month 4, things start to get dicey. Three of the last 12 traffic stops have resulted in shootouts with the occupants of the cars stopped. While nobody was killed and only two people wounded (both of them suspects), the shooting appears to be taking its toll on the new officer.

When going to the car last week at the start of shift, an officer in an adjacent car slammed the trunk lid, causing a loud bang. As you turned toward your car, you found your partner on the ground trying to scoot under the vehicle. Four nights earlier, you were called to back up another unit that had a high-risk stop. Upon your arrival, you drew your weapon and ran up to the other unit, two officers who were wrestling with two suspects. After the suspects were handcuffed, you turned to find your partner crouching behind your unit shaking. When you tried to talk to him about it, he said he was starting to get the flu. The next night he called in sick.

The night following the sick night, while on patrol, you stopped a suspect vehicle, and the driver was a huge sawmill worker with 3 outstanding felony warrants for robbery and assault. The suspect attacked you, and you rolled around on the ground for a full 45 seconds trying to get the suspect handcuffed. After getting him under control you looked up to see your partner frantically screaming on the radio for back up about 30 feet away. He never came to your aid during the incident.

The unit commander suspects that there is a problem and asks you to write a fitness report on your new partner with recommendations for follow-up on the report you submit.

In a report to the unit commander of the special highway patrol unit, indicate the issues in the scenario that cause you concern about the new officer. You will identify how the symptoms displayed by the new officer are consistent with post-traumatic stress disorder (PTSD). You will provide at least 2 recommendations for action concerning the new officer. You will provide the commander with options on what you think can be done to prevent this type of problem in the unit.

Assignment Guidelines

 

  • Address the following in 2–3 pages:
    • How important is it for partners to react appropriately in the field? Explain.
    • What are the key symptoms that may be observed in the partners actions and reactions in the scenario? Explain.
    • What are the symptoms of post-traumatic stress disorder on the part of the partner in the scenario? Explain.
    • What are 2 specific actions that should be taken concerning the partner? Explain.
  • Address the following in 2–3 pages:
    • Select 2 personality disorders common to surviving victims of a life-threatening experience other than post-traumatic stress disorder.
    • For each selected personality disorder, address the following questions:
      • What are the symptoms of this disorder? List and describe.
      • What types of people typically succumb to this disorder? Explain.
      • How can individuals with this disorder be treated? Explain.
  • Be sure to reference all sources using APA style.

Eco 550 Assignment

Imagine that you work for the maker of a leading brand of low-calorie microwavable food that estimates the following demand equation for its product using data from 26 supermarkets around the country for the month of April.

For a refresher on independent and dependent variables, please go to Sophia’s Website and review the Independent and Dependent Variables tutorial, located athttp://www.sophia.org/tutorials/independent-and-dependent-variables–3.

Note: Your professor will provide you with the equation and data necessary for you to complete thisassignment. You will find this information attached to Assignment 1 within the course shell.

Write a four to six (4-6) page paper in which you:

  1. Compute the elasticities for each independent variable. Note: Write down all of your calculations.
  2. Determine the implications for each of the computed elasticities for the business in terms of short-term and long-term pricing strategies. Provide a rationale in which you cite your results.
  3. Recommend whether you believe that this firm should or should not cut its price to increase its market share. Provide support for your recommendation.
  4. Assume that all the factors affecting demand in this model remain the same, but that the price has changed. Further assume that the price changes are 100, 200, 300, 400, 500, 600 dollars.
    1. Plot the demand curve for the firm.
    2. Plot the corresponding supply curve on the same graph using the supply function Q = 5200 + 45P with the same prices.
    3. Determine the equilibrium price and quantity.
    4. Outline the significant factors that could cause changes in supply and demand for the product. Determine the primary manner in which both the short-term and the long-term changes in market conditions could impact the demand for, and the supply, of the product.
  5. Indicate the crucial factors that could cause rightward shifts and leftward shifts of the demand and supply curves.
  6. Use at least three (3) quality academic resources in this assignment. Note: Wikipedia does not qualify as an academic resource.

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:

  • Analyze how production and cost functions in the short run and long run affect the strategy of individual firms.
  • Apply the concepts of supply and demand to determine the impact of changes in market conditions in the short run and long run, and the economic impact on a company’s operations.
  • Use technology and information resources to research issues in managerial economics and globalization.
  • Write clearly and concisely about managerial economics and globalization using proper writing mechanics.