Archive for category: My Nursing Writer

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS AND EXECUTE THE QUERIES ON THE ‘ORIENTALBANK’ DATABASE YOU CREATED ABOVE USING MS ACCESS. (20 MARKS)

Assessment Details and Submission Guidelines
Unit Code MN405
Unit Title Data and Information Management
Assessment Type Assignment 1 (T2 2017)
Assessment Title Managing Data in Databases
Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop skills in managing data in databases and to gain understanding of data model development and implementation using a commercially available database management system development tool.
On completion of this assignment students will be able to:
a. Model organisational information requirements using conceptual data modelling techniques.
b. Convert the conceptual data models into relational data model
Weight 60 Marks
Total Marks 20% of total assessment for the unit
Word limit No specific word limit
Due Date La Week 8
Description of this assignment: This assignment consists of three Questions:
Question 1: Designing a database using the Ms-Access.
Question 2: Implementing the SQL Commands
Question 3: Normalisation
Submission Guidelines • All work must be submitted on Moodle by the due date.
• The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font and 2.5 cm margins on all four sides of your page with appropriate section headings.
• Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using IEEE referencing style.
Extension • If an extension of time to submit work is required, a Special Consideration Application must be submitted directly to the School’s Administration Officer, in Melbourne on Level 6 or in Sydney on Level 7. You must submit this application three working days prior to the due date of the assignment. Further information is available at:
http://www.mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/specialconsiderationdeferment
Academic Misconduct
• Academic Misconduct is a serious offence. Depending on the seriousness of the case, penalties can vary from a written warning or zero marks to exclusion from the course or rescinding the degree. Students should make themselves familiar with the full policy and procedure available at:http://www.mit.edu.au/about-mit/institute-publications/policies-procedures-and-guidelines/Plagiarism-Academic-Misconduct-Policy-Procedure.For further information, please refer to the Academic Integrity Section in your Unit Description.

Assignment Description
1. Below is the entity-relationship diagram for the banking database application, there are four relations/tables in their database describing banking application details, details of projects, work assigned for each branch and account, namely, BRANCH, ACCOUNT, CUSTOMER and TRANSACTION. The relationship diagram for these relations are given below.
(20 Marks)

A. Write one paragraph describing the E-R diagram above in your own language
B. Implement above database on MS Access. You are required to create the above 4 tables with the given attributes. Name the database as ‘OrientalBank’.
C. Enter at least 10 data records for each table in the database you created in (a) above. Here you have to enter data into all 4 tables.
D. Write 4 examples of report cards that can be generated using the ‘OrientalBank’ database.
E. Write down the shorthand representation (database schema) of the structure of a relational database for the above E-R diagram
F. What is a primary key? What is the primary key for each table in the ‘OrientalBank’ database.
2. Write SQL queries for the following questions and execute the queries on the ‘OrientalBank’ database you created above using MS Access.
(20 Marks)
A. Creating the four tables.
B. How many accounts have a balance greater than $500.
C. Display the Name, of all accounts with a balance greater than the average balance.
D. Find the ID, Name, Transaction number, date and type of the second account.
E. Find details of customers having their account in the second bank branch.
F. List the numbers and names of all customers.
G. List the complete account table.
H. List the account number and name of all customers that have opened their accounts in the second branch and that have a balance less than $1,000.
I. List the number and name of all customers that have opened their accounts in the second branch or that have a balance less than $1,000.
J. List the number and name of all customers who have opened an account in the “Melbourne city” branch.
K. Find the total of the balances for all accounts.
3. Write the 1NF, 2NF, 3NF for the below data.
(20 Marks)
HEALTH HISTORY REPORT
PET ID PET NAME PET TYPE PET AGE OWNER VISIT DATE PROCEDURE
246 ROVER DOG 12 SAM COOK JAN 13/2002 01 – RABIES VACCINATION
MAR 27/2002 10 – EXAMINE and TREAT WOUND
APR 02/2002 05 – HEART WORM TEST
298 SPOT DOG 2 TERRY KIM JAN 21/2002 08 – TETANUS VACCINATION
MAR 10/2002 05 – HEART WORM TEST
341 MORRIS CAT 4 SAM COOK JAN 23/2001 01 – RABIES VACCINATION
JAN 13/2002 01 – RABIES VACCINATION
519 TWEEDY BIRD 2 TERRY KIM APR 30/2002 20 – ANNUAL CHECK UP
APR 30/2002 12 – EYE WASH

Marking criteria:
Marks are allocated for each part as above:
Marking Rubric for Assignment 1 –Part B: Total Marks 60
Excellent Very Good Good Satisfactory Unsatisfactory
Query writing
skills Evidence of accurate and well-
written queries Evidence of good query writingskills. Generally relevant. Displayed reasonable query writing skills. Demonstrated little evidence of understanding the topic.
Identification
Demonstrated excellent ability to think critically. Demonstrated anability to think critically. Demonstrated reasonable ability to think. Demonstrated some ability to think critically but not complete. Did not demonstrate ability to think critically.
Analyse
Logic is clear and easy to follow. Consistency logical and convincing. Mostly consistent logical and convincing. Adequate cohesion and conviction. Arguments are confused and disjointed.
Design /Presentation

---

 

. .

---

---

The post WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS AND EXECUTE THE QUERIES ON THE ‘ORIENTALBANK’ DATABASE YOU CREATED ABOVE USING MS ACCESS. (20 MARKS) appeared first on My Nursing Writer.

Identify a position that is open or has recently been filled in your organization.Using what you know about the position, the culture and expectations of the organization, your own hiring and selection experiences, and this week’s readings

Identify a position that is open or has recently been filled in your organization.
Using what you know about the position, the culture and expectations of the organization, your own hiring and selection experiences, and this week’s readings, investigate the following:
Identify the selection steps that have been or will be taken, as well as the members involved. For example, which steps did human resources complete? In which steps did the nursing manager engage?
Identify the skills, educational and work background, and “fit” required for this position. How do these align with the advertised job description?
Identify any problems or areas that could be improved in your organization’s current selection process. If you were the nurse manager, how would you modify this process?

---

 

. .

---

---

The post Identify a position that is open or has recently been filled in your organization.Using what you know about the position, the culture and expectations of the organization, your own hiring and selection experiences, and this week’s readings appeared first on My Nursing Writer.

Formulate and discuss your personal definition of nursing, person, health, and environment.

---

 

. .

---

---

The post Formulate and discuss your personal definition of nursing, person, health, and environment. appeared first on My Nursing Writer.

Recommend one (1) approach that the hospital could use for acquiring a larger market share given the prevailing financial circumstances.
Final Case Study: Consulting for the Caring Angel Hospital
Due Week 10 and worth 300 points

Imagine that you are a senior consultant at Practical Health Care Consulting firm. Your supervisor has instructed you to spend three (3) months at the Caring Angel Hospital to help improve the quality of care, add value to the organization, improve employee morale, design an efficient organizational chart, create a strong team environment, and create the hospital’s competitive advantage. The hospital has traditionally made losses year after year. Furthermore, it is not performing well financially, and the banks are not willing to lend it large sums of money for more effective marketing.

After spending two (2) months within the hospital, you are very happy with your progress, and you think you are capable of acquiring more patient base and expanding the hospital market. However, with a closer look, you notice that your patients are still hopping from one specialized hospital to another in search of various specialized treatments. You also notice that the seats are not comfortable in the waiting area, and the patients continuously show up for appointments on the wrong dates. The nurses and the employees are not smiling during patient conversations, and everyone looks for ways to blame others for failures in the patient treatment process. Everyone seems to work alone and hide what they do from their colleagues.

At the end of the three (3) month period, you must provide a report with your recommended strategies designed to help Caring Angel Hospital achieve its goals.

Note: You may create and / or make all necessary assumptions needed for the completion of this assignment.

Write a four 4) page paper in which you:

From a consulting perspective, propose the major steps that Caring Angel Hospital could take to achieve each of the following goals:
Improve the quality of care
Add value to the organization
Improve employee morale
Design an efficient organizational chart
Create a strong team environment
Create the hospital’s competitive edge.
Recommend one (1) approach that the hospital could use for acquiring a larger market share given the prevailing financial circumstances. Justify your recommendation.
Investigate at least two (2) value-added services that Caring Angel Hospital could offer to strengthen its value proposition. Provide at least two (2) examples of the advantages of these value-added services to the hospital.
Use four (4) recent (within the last five [5] years) quality academic resources in this assignment.
Note: Wikipedia and other websites do not qualify as quality academic resources.

---

 

. .

---

---

The post Recommend one (1) approach that the hospital could use for acquiring a larger market share given the prevailing financial circumstances. Final Case Study: Consulting for the Caring Angel Hospital Due Week 10 and worth 300 points appeared first on My Nursing Writer.

Why do drug firms give discounts voluntarily? Do other healthcare providers routinely give discounts to some customers? Why do the uninsured typically pay the highest prices?
Economics of Health Care

Electronic mail:

Engineercatracho

At

Yahoo

Dot

Com

*Please send me a confirmation

Assignment 1: Power Point

Due Date: 11/27/2016

Managers Economic Proposal: Prepare an 8–12 slide PowerPoint (.ppt or .pptx file) presentation using a minimum of two (2) slides per initiative. Elements of Presentation:

Use a maximum of six bullets on each slide with highlights of the information you would present if you were in front of your audience.

Include speaker notes in the speaker notes section based on what you will verbally present or you may opt for voice overs (recorded presentation on each slide).

Include a thorough, clear, and concise introduction of the overall initiatives. Be creative to draw the audience into the presentation with compelling questions, or by relating to the audience’s interests of your hypothetical health care organization

Using your approved initiatives, develop a presentation that includes, but is not limited to, the following elements:

Introduction your hypothetical health care organization/facility establishing your audience.

Explanation of your approved initiatives brief implementation plan.

Purpose of your initiatives (what is the significant affiliation to health care organizations).

How your initiatives influence health care organizations.

How your initiatives relate specifically to health care management.

How your initiatives interconnect to economical concepts and principles.

Include a minimum of three (3) scholarly references (one for each initiative) from the Excelsior Library in addition to the textbook. Please properly cite each slide, list all references on the reference slide, and include a title slide, all in APA format. For PowerPoint assistance, view PowerPoint Tutorials (Atomic Learning) available to you through the Video Tutorials link in left course toolbar.

*NOTE: I do not have the initiatives approved yet.*

Assignment 2: Two-page paper

Due Date: 11/6/2016

Case Study: (Will be provided)

Price discrimination is common in healthcare, as well as other industries. Price discrimination can increase profits. Read case study 12.1 in the textbook on price discrimination and compose a case study report that follows the recommended format in the “Case Study Rubric”.

Write a two-page, double-spaced paper in APA format, including a title and reference page. Cite and reference the Lee textbook and two additional scholarly resources from the readings

Include evidence on price discrimination and address the following questions in your paper narrative (do not copy and paste questions and answer one at a time, but rather integrate the answers as appropriate in your written text. Q & A format is not acceptable):

---

 

. .

---

---

The post Why do drug firms give discounts voluntarily? Do other healthcare providers routinely give discounts to some customers? Why do the uninsured typically pay the highest prices? Economics of Health Care appeared first on My Nursing Writer.