Blog

Develop a conceptual data model diagram

Develop a conceptual data model diagram

Assignment

Objectives

– To develop a conceptual data model diagram
– To perform logical design

Assignment Specification

In this assignment, youneed to perform the followingtasks for the given case study:
– Draw an Entity Relationship (ER) diagram
– Perform logical design
– Create3NF Relations

Case Study

Many medical specialists offer their medical consultations and perform special medical procedures to the patients at CQ Specialist Medical Center (hereafter called as CQMC). Patients generally book their appointments through a telephone call or by personal visits to the center. Sometimes, the General Medical Practitioners (GPs) contactCQMC directly on behalf of their patients for the specialist appointments.

The patient details, such as name, gender, etc., are collected and stored at CQMC. Since the name of the patient is not going to be unique, each patient is identified by a unique patient ID. The details of patient’s medical history (past surgeries undertaken), details of current medications (medicines and dosages) and other medication-allergies, if any, have to be maintained by CQMC. The referral letter from a GP is not a requirement at the time of booking for an appointment with the specialist but it is compulsory at the time of actual patient’s consultation. Just prior to the consultation, CQMC collects the referral letter from the patient and notes down the details of date of referral and the GP (identified by unique Medical Provider Number) who issued that referral letter. Based on the necessity, the same GP may refer the same patient to the same specialist many times over a period of time. During the consultation, a specialist may conduct various medical tests and procedures on the patient; may prescribe multiple prescriptions to the patient. After each appointment, the name of the standard tests and procedures performed along with the medical prescription details are stored and maintained by CQMC.

The following table provides the details of consultation and other charges applicable for the specialist’s appointments. The charges can be assumed to be constant values.

Type Fees/Charges
Consultation $120
Biopsy $75
Excision $175
Laser $250

Type Fees/Charges

After each appointment, the patient pays the entire appointment charges to CQMC. Each appointment charges include the consultation fees and additionally may include multiple other charges from the above table. Sometimes, some specialists offer discount amount to some appointments on special grounds such as Pensioner, Veteran etc.,

Some GPs and patients often would like to know the details of qualifications and number of years of experience of the specialists. Hence, CQMC maintains and updates those details periodically. You may note that a medical specialist may have multiple qualifications.
The attributes of the possible entities have not been mentioned clearly. Hence, you need to assume at least three and at most seven relevant attributes for each of the entities that you will identify for your ER diagram.

Assignment Requirements

In this assignment,you need to create an Entity Relationship (ER) diagram relevant to the above case study and perform logical design to produce appropriate3NF Relations.

The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.

Draw an appropriate ER diagram

Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study.

Your ERD must
– show all necessary entities, attributes andrelationships
– show identifiers/identifying attributes as necessary
– show multi-valued attributes, ifany
– show participation andcardinality
– show associative entities, ifappropriate
– show weak entities, if any
– use the notation described in the settext
– use consistent and appropriate naming for entities and attributes as specified in the unit text book

Design a evaluation plan to measure efficacy of the proposed

Design a evaluation plan to measure efficacy of the proposed

Overview/Description:

The purpose of this assignment is to provide the student an opportunity to design a health promotion proposal specific to your role specialization.

Each student will write a scholarly paper that demonstrates graduate school level writing and critical analysis of existing nursing knowledge.

The paper will be a minimum of 12 pages and maximum of 15 pages, using APA style.

There are multiple sections to the project. These include:

Identification of a specific health promotion topic, along with a well-defined target population.

Critically analyze the current literature related to this topic, .

Create an intervention plan for the identified problem.

Create an evaluation plan for the intervention, which is due in Week 5, along with all other project sections.

The final project is due in Week 5 and will be composed of the above sections which you will adjust weekly based upon the feedback from your facilitator. All sections will be submitted in one document. Additional explanation for each section is provided in the relevant week’s directions.

Project-Specific Criteria:

Clearly describe the health promotion/disease prevention problem specific to the target population.

Explain how the selected problem applies to advanced practice in the student’s role option.

Critically analyze the current literature related to interventions that address the problem related to communities from nursing, the sciences, and humanities.

Select an appropriate health promotion/disease prevention theoretical framework that applies to the problem.

Design an intervention to address the problem in the selected population/setting using appropriate epidemiological, social, and environmental assessments.

Design an evaluation plan to measure efficacy of the proposed intervention.

Choosing Your Topic

The frist step in the project is to identify a topic appropriate for a health promotion project. There are multiple areas to look for acceptable projects, such as the Health People 2020 site, The Institute of Medicine, Centers for Disease Control (CDC), National Institute of Nursing Research (NINR), Agency for Health Care Research and Quality (AHRQ), and current literature in the South University library. You may also want to look at the websites for professional nursing organizations who may also have listings of health promotion priorities.

If you have any difficulty in identifying the topic, please talk to your instructor. Once you are clear on the area of interest, narrow the topic to something that is specific and measureable. For example, if you are interested in the care of the elderly, you may want to focus on a project to lessen the fall rate for the elderly.

Difference in practitioner-scholar and scholar practitioner

Difference in practitioner-scholar and scholar practitioner

Read McClintock’s 2003 entry, “Scholar Practitioner Model” in DiStefano, Rudestam, and Silverman’s Encyclopedia of Distributed Learning, pages 394-397.

1). What is the difference between “Practitioner-Scholar” and “Scholar Practitioner”?

2). In your own words, what does it mean to be a (“Practitioner-Scholar”) within the field of psychology?

Discuss three of the six principles of military deception

Discuss three of the six principles of military deception

1. You may deviate from the following questions and reflect on the posting of reclusive North Korean boy-Dictator Kim Jong Un’s absence. See First posting.

2. How did the core concepts of Denial and Deception operate in these, and other historic examples?

3. Why did these efforts succeed, or fail?

4. Discuss how the core concepts from Homer, Sun Tzu, or Shakespeare continue to be applicable within the modern era.

5. Describe the use of the three of the six principles of military deception which occurred within the Civil War reading.

Explain parenting style of collectivist-individualist parent

Explain parenting style of collectivist-individualist parent

Imagine that you are watching a new reality television show in which parents trade places and take one another’s role in the family. In the program, parents interact with the grandparents in addition to parenting one another’s children. One family is characterized as coming from a collectivist culture, and the other family is characterized as coming from an individualist culture. Each family has one 1-year-old, one 8-year-old, one 14-year-old, and two grandparents living in the household.

To complete this Assignment, 3-page paper that includes the following:

Explain the differences in parenting style of “collectivist” and “individualist” parents. Describe how each couple would differ in their expectations of each of the children.

In light of the differing styles and expectations, analyze the points of conflict that would arise when the parents were swapped. Be sure to identify how the collectivist parents would respond to the individualist children as well as how the individualist parents would react to the collectivist children.

Compare the grandparents’ role in the collectivist family to the grandparents’ role in the individualist family. Identify the conflicts that these roles would cause when the parents were swapped. Then speculate about how the “new” mother and father may wish to change the existing roles?

Offer your conclusion about how you anticipate the show will end. Will any of the family members adjust their beliefs or behaviors?
Support your Assignment with specific references to all resources used in its preparation.

Describe methods of personnel management in medical office

Describe methods of personnel management in medical office

Assignment: Responsibilities of the Office Manager

Unit outcomes addressed in this Assignment:

• Differentiate among the types of management styles as listed in the textbook.
• Discuss the goals and management principles of an office manager.
• Illustrate the importance of a medical office policy manual.
• Develop the basic groundwork of an office policy manual.

Course outcome(s) addressed in this Assignment:

Describe methods of personnel management in the medical office.

Instructions:

The Final Project for this course is for you to design and develop an effective Policy and Procedure Manual based on the information you have learned throughout this course. You will begin working on this manual now. For your Assignment, you will need to turn in an outline of the first four sections of your Policy and Procedure Manual.

The first four sections need to include the following (the back of your book has examples):

1. A mission statement (at least three sentences)

2. About the practice: Name of office and doctor(s), any specialty they practice, location, office hours, list of holidays office is closed

3. Employee benefits (add descriptions for each one): Vacation, sick leave, medical, dental, retirement, bereavement, FMLA

4. Employee conduct and discipline (add descriptions for each one)

For the completed manual due in Unit 9, you will be adding the remaining sections:

5. Confidentiality (complete the description in final manual)

6. Training period (complete the description in final manual)

7. Salary and when paid: monthly, biweekly (complete the description in final manual)

8. Signed employee acknowledgement page.

Explain nonargumentative persuasion or pseudoreasoning

Explain nonargumentative persuasion or pseudoreasoning

Explain any instances of nonargumentative persuasion or pseudoreasoning and describe any slanting techniques you find in following passage. Rewrite passage in language which is as emotively neutral as possible but still retains same informational content.

“U.S. government is about to give away resource that is worth more than any national park or national monument in the land. If public were to hear that Yosemite or Yellowstone National Park were to be handed over, at no cost, to major corporation, what do you believe would occur? There’d be howls of protest, of course. But the even bigger giveaway is in works: awarding of large segments of the broadcast spectrum to broadcasting systems. They will be able to turn huge profits from new resources, and how much comes back to public?

Describe the role of men and women in his sex role theory

Describe the role of men and women in his sex role theory

How does Talcott Parsons describe the role of men and women in his “sex role theory”? Explain how conflict theories can be seen as a critique of structural functionalism and describe some limitations of each approach. How has the increasing participation of women in education and the work force and the acceptance of gay couples changed the traditional sex roles? Response should consist of 6-8 paragraphs