Get help from the best in academic writing.

Health Care technology

Develop a graphical taxonomy of the different health care
technologies using Microsoft Excel. The taxonomy should include
information on the following:
1. Type of health care technology.
2. Brief discussion regarding how each technology contributes to the health care system in the US when applicable.
3. Assess how each medical technology type affects or affected clinicians and organizations.
Part II. Provide a 75-100 word response to the following questions:
4. Discuss trend(s) that have directly impacted the U.S. population and
health care over the last 50 years. Provide specific details.
5. Determine one (1) important factor that has had the greatest impact on the health care utilization pattern(s).
Be typed, double spaced, using Times New Roman font (size 12), with
one-inch margins on all sides; references must follow APA format

Assignment 4: database modeling and normalization

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

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 Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

Health Care Technology

Develop a graphical taxonomy of the different health care
technologies using Microsoft Excel. The taxonomy should include
information on the following:
1. Type of health care technology.
2. Brief discussion regarding how each technology contributes to the health care system in the US when applicable.
3. Assess how each medical technology type affects or affected clinicians and organizations.
Part II. Provide a 75-100 word response to the following questions:
4. Discuss trend(s) that have directly impacted the U.S. population and
health care over the last 50 years. Provide specific details.
5. Determine one (1) important factor that has had the greatest impact on the health care utilization pattern(s).
Be typed, double spaced, using Times New Roman font (size 12), with
one-inch margins on all sides; references must follow APA format

Database modeling and normalization

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

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 Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

Math

Save your file in a location that you will remember. When you are ready to submit it, go to the Dropbox. You will be able to come back to the Dropbox and view your graded work or in the Gradebook after your instructor evaluates it.
Get started on the assignment by watching the Should I Buy a House? video on the link below then answer the following questions.
http://media.pearsoncmg.com/ph/esm/chet_cleaves_cbsm9e_12/tools/RealWorldCase_before.htm
Joe has decided that he is tired of paying rent and not building equity of his own. He thinks that he is ready to assume the responsibility of owning a home and has found what he believes is the perfect first home. Joe meets with the loan officer at his bank where the process of buying a home is started. The loan officer provides Joe with a great deal of information, leaving him excited and apprehensive at the same time.
What you know:
The purchase price of the house is $75,000.
Joe has $10,000 in savings.
Joe makes $15 per hour and works 40 hours per week.
30-year mortgage interest rate of 6.25% and a monthly payment of $439.00
15-year mortgage interest rate of 5.25% and a monthly payment of $575.00
Down payment: 5% minimum
Taxes last year were $375.
Insurance is $250 per year.
What you are looking for:
Can Joe afford the monthly payments with taxes and insurance for either a 30 or 15 year mortgage?
If Joe buys the house, will he have enough money left over on a monthly basis to live comfortably?
Does Joe have enough in savings to pay for the down payment and all of the closing costs?
Solution Plan:
Complete the following questions based upon the information in the video and other information provided in the worksheet.
Joe figures that with overtime he will average 40 hours a week for 52 weeks a year. If his current wage is $15.00 per hour, how much will he make per year?
How much would Joe’s wages be in an average month?
Based upon the information in the video, Joe has a car payment of $249 per month. The average utilities are: Electricity, $79; Gas, $49; Water, Sewer, and Trash, $27. In addition, Joe is saving $100 per month. How much of his monthly salary would be committed to utilities and other expenses?
If Joe’s net income after taxes each month is equal to 74% of his gross wages, how much is his net income?
Joe’s total monthly payment to the bank will consist of the mortgage interest plus principal amount plus monthly payments for insurance and taxes. What will the total monthly payments be for a 15-year and a 30-year loan including taxes and insurance?
After paying for his car, utilities, and a 15-year mortgage payment how much will he have left to cover other living expenses? If he goes with a 30-year mortgage, how much will he have left over to cover living expenses?
Make a list of your living expenses and try to estimate monthly expenses. Does Joe have enough left over to live comfortably if he buys the house? Should he go with the 15 or the 30-year mortgage?
Complete the Good Faith Estimate to see if Joe has enough money in savings for the down payment and closing costs:
Description of FeeAmount of FeeExtended AmountDown Payment5% of purchase priceLoan Origination FeeNo fee at this bankPointsNo points on this loanAppraisal Fee$400Credit Report$50Insurance—First Year Premium$250Mortgage insurance$45 (one month)Escrow Account Insurance reserveInsurance for two months ($250 / 12) * 2Escrow Account Tax reserveProperty Taxes for two months($375 / 12) * 2Attorney feesBuyer’s choice. None here.Title Insurance$700Processing/Underwriting$100Document Preparation and Recording Fees$250Survey$125Tax Service$50Flood Certification$20Title Co. Fee$150Pre-paid InterestDepends on closing date: Estimate $150.00Total Due at Closing:

Essay Writing at Proficient Essay

5.0 rating based on 10,001 ratings

Rated 4.9/5
10001 review

Review This Service




Rating: