Premium Essay

Health Concept Assignment

In:

Submitted By xdriver007
Words 1250
Pages 5
Part 1: Wellness Center
The Wellness Center currently tracks its members using a spreadsheet, and wants to upgrade to using a relational database. You have been tasked with this conversion, and need to convert this flat field design into a relational database design.
The Wellness Center has given you its current spreadsheet design, which contains the following fields (columns).

• Member ID • Member Name • Member Phone • Member Email • Health Plan Level Name • Health Plan Level Description • Health Plan Price • Price w/tax • Paid Until Date • Member Since • Event 1 Name • Event 1 Description • Event 1 Attended • Event 2 Name • Event 2 Description • Event 2 Attended • Event 3 Name • Event 3 Description • Event 3 Attended
The Wellness Center has also given you the following business rules, which are incomplete and are not all necessarily structural. • Members purchase a yearly health plan. • The health plans are one of three levels: Basic, Deluxe, or Executive. • Health plans are generally paid for once per year. • Three special Healthy Living Symposium events are offered each year. Attendance is tracked for each member.

1. To get started, create a complete list of business rules that you will use as a basis for your logical diagram. Your list of business rules should specify all entities, relationships, optionality constraints, and plurality constraints, and must make provision for the data and business rules given to you by the Wellness Center. There are many solutions that will correctly make provision for the given data and business rules.

2. Now create a logical entity-relationship diagram (ERD) that illustrates the relational database design described by the business rules in #1. All entities should be normalized to BCNF. Recall

Similar Documents

Premium Essay

Random

...Personal Food Diary Guidelines Purpose The purpose of this assignment is to increase self-awareness of the student by analyzing personal nutritional intake and activity routine throughout the course. In turn, the student will be able to help others modify their diet and activity, and improve overall wellness. An examination of a personal food and activity assessment will provide the student with essential data from which to change their health and wellness behaviors. Course Outcomes This assignment enables the student to meet the following course outcomes: CO #1 Assess whether nutritional intake provides basic nutrients for optimal health and wellness. (PO #1, PO #2) CO #2 Describe nutritional needs for optimal health and wellness throughout the life span. (PO #1, PO #2) CO #3 Discuss the psychological, sociological, economical, and cultural implications of food on nutritional status. (PO #1, PO #2) CO #4 Describe evidence-based interventions and modifications in nutrition therapy that can positively influence the outcome of disease and illness. (PO #1, PO #8) Due Date Refer to Course Calendar for campus requirements. Online will submit by Sunday, Unit 7 11:59 pm MT. Total Points Possible: 100 Requirements 1. Create a concept map document based on the food and activity journal throughout the course using www.chooseMyPlate.gov. The discussion questions in units 1, 3, 5, & 7 will provide you with questions on what aspect of diet to focus on. You are...

Words: 1481 - Pages: 6

Premium Essay

Implications of Health Economic Concepts for Healthcare

...Assignment 1: Implications of Health Economic Concepts for Healthcare Select at least five (5) economic concepts covered in the first four weeks’ readings, and discuss the primary manner in which these concepts impact the world of health care economics. Some examples of selected concepts are health demand and supply, elasticity, resources, health measures, and costs. Write a four to six (4-6) page paper in which you: 1. Assess the value of healthcare professionals and decision makers understanding the discipline of health economics. 2. Defend or critique the importance of considering the complex nature of health and healthcare when examining the economic principles related to healthcare delivery. 3. Analyze the primary potential benefits of learning about health economics related to government involvement in healthcare economics, financing, and delivery. 4. Analyze the main potential benefits of learning about health economics related to private sector government involvement in healthcare economics, financing, and delivery. 5. Use at least five (5) current references. Three of these references must be from current peer-reviewed sources to support and substantiate your comments and perspectives. 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...

Words: 352 - Pages: 2

Premium Essay

Hcs 405 Week 1 Health Care Financial Terms Worksheet Paper

...HCS 405 week 1 Health Care Financial Terms Worksheet Paper - WWW.STUDENTWHIZ.COM Introduction The HCS 405 week 1 financial terms worksheet throws light on some of the most basic concepts of the healthcare business. Understanding health care financial terms is a prerequisite for both academic and professional success. The health care business helps the nation by providing the building blocks that the citizens need to live a successful and healthy life. The worksheet is intended to ensure that the students understand some of the basic terms used in the business world of the health care industry. The purpose of HCS 405 individual and team assignments is to make the students aware about the numerous strategies employed in the financial and other departments of a health care sector. The students attending to the HCS 405 need to understand the significance of the healthcare industry. The employees of the company strive hard every day to fulfill the mission of the company by providing millions of families, seniors, and children of the country with access to good quality healthcare products and services. The questions are strategically framed to bring out the major theme of each of the HCS 405 week assignments. For example, decision-making is the process of making sound financial decisions with the aid of your controlling, organizing, and planning results and analysis. It defines the roles for various employees of the company like the financial manager. There is a need for the mangers...

Words: 1037 - Pages: 5

Premium Essay

Comunity Mobilization

...Michael Wilson Ibet- Iragunima Rivers State College of Health Science and Technology Port Harcourt Prof. Afolabi Adebanjo School of Science and Technology National Open University of Nigeria, Lagos Programme Leader Course Coordinator Kayode S. Olubiyi School of Science and Technology National Open University of Nigeria, Lagos National Open University of Nigeria Headquarters 14/16 Ahmadu Bello Way Victoria Island Lagos Abuja Annex 245 Samuel Adesujo Ademulegun Street Central Business District Opposite Arewa Suites Abuja E-mail: centralinfo@nou.edu.ng URL: www.nou.edu.ng National Open University of Nigeria 2008 First Printed 2008 ISBN: All Rights Reserved Printed by…………………………………. For National Open University of Nigeria Headquarters 14/16 Ahmadu Bello Way Victoria Island Lagos e-mail: centrainfo@nou.edu.ng ur/: www.nou.edu.ng Study Units The study units in this course are as follows: Module 1: Unit I: Unit 2: Unit 3: Unit 4: Unit 5: Unit 6: Community Mobilization Concept of Community Mobilization Rationale for Community Mobilization Steps involved in Community Mobilization Community Participation Rationale for Community Participation Formation and Organization of Development Committees Community Diagnosis Concept of Community Diagnosis Rationale for Community Diagnosis Steps in Community Diagnosis Methods for Community Diagnosis Information Sought During Community Diagnosis Situation Analysis Concept of Situation Analysis Rationale for Situation Analysis...

Words: 15685 - Pages: 63

Premium Essay

Ghij

...North South University Department of Public Health Course: Introduction to Public Health Course Code: PBH 101 Spring 2014 Course Instructor: Dr. Mohammad Hayatun Nabi Course Outline General Information University: North South University Department: Department of Public Health Course Information Course name: Introduction to Public Health Course Code: PBH 101 Section: 3 Mode of Delivery: Face to face Teaching Information Teaching Session: Spring 2014 Course Instructor: Dr. Mohammad Hayatun Nabi Room- 823 hayat4008@yahoo.com Lecture Time: Sunday and Tuesday, 1.00pm- 2.30pm, Room# 403 Attendance Requirements: Students are expected to attend all the lectures. Student Consultation: Sunday and Tuesday- after the class. University Policy Students should be familiar with all University rules, policies and processes, related to their studies and time at University. Student Academic Misconduct The University takes any form of academic misconduct seriously. Academic misconduct is conduct on the part of a student, which involves amongst other forms of misconduct: Cheating, Plagiarism and collusion. Student Responsibilities Students have a responsibility to: 1. familiarize themselves with the University policy on assessment and examinations; 2. ensure they read and understand the assessment requirements and seek assistance from the instructor when needed; 3. submit for assessment...

Words: 684 - Pages: 3

Premium Essay

Hlt 310v Week 3 Complete Assignment and Dq

...HLT 310V WEEK 3 COMPLETE ASSIGNMENT AND DQ To purchase this tutorial visit here: http://wiseamerican.us/product/hlt-310v-week-3-complete-assignment-dq/ contact us at: SUPPORT@WISEAMERICAN.US HLT 310V WEEK 3 HLT 310V Week 3 Topic 3 DQ 1 Read Colossians 1 in the Bible. Compare ways in which the concepts of “God,” “Person,” “Environment,” “Health,” and “Nursing” would be defined according to Colossians 1. HLT 310V Week 3 Topic 3 DQ 2 What tensions do you think you might experience arising from the differing worldviews of administrators, health care providers, and patients? Base your response from the GCU introduction and the textbooks. Cite references from your reading to support your answer. HLT 310V Week 3 Assignment Health Care Provider and Faith Diversity: First Draft Max Points: 100 Details: The practice of health care providers at all levels brings you into contact with people from a variety of faiths. This calls for knowledge and acceptance of a diversity of faith expressions. The purpose of this paper is to complete a comparative analysis of two faith philosophies towards providing health care, one being the Christian perspective. For the second faith, choose a faith that is unfamiliar to you. Examples of faiths to choose from: Sikh, Baha’i, Buddhism, Shintoism, etc. In a minimum of 1,500-2,000 words, provide a comparative analysis of the different belief systems, reinforcing major themes with insights gained from your research. In your comparative analysis...

Words: 2501 - Pages: 11

Premium Essay

Course Sysa

... | | |Finance for the Health Care Professional | Copyright © 2011, 2009, 2007 by University of Phoenix. All rights reserved. Course Description This course is designed as an introduction to the terminology, processes, functions, and financial reports commonly encountered in health care operations. This course introduces the concepts of basic managerial financial functions, such as budgeting, reimbursement methods, and the responsibilities of health care financial management. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged into the student website to view this document. • Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality. Course Materials Baker, J. J., & Baker, R. W. (2011). Health care finance: Basic tools for nonfinancial managers (3rd ed.). Sudbury, MA: Jones & Bartlett Publishers. All electronic materials are available...

Words: 2805 - Pages: 12

Premium Essay

Hlt 324v Week 1 Complete Latest

...WEEK 1 COMPLETE LATEST To purchase this tutorial visit here: http://wiseamerican.us/product/hlt-324v-week-1-complete-latest/ contact us at: SUPPORT@WISEAMERICAN.US HLT 324V WEEK 1 COMPLETE LATEST HLT 324V Week 1 Discussion 1 Describe the concept of “variant characteristics of culture.” Which characteristics can change and which cannot? Is equality for variant cultures typically supported in the United States? Provide examples to support your statement. HLT 324V Week 1 Discussion 2 How does cultural competency occur? What can one do to become culturally aware? Describe an effective approach to using The Purnell Model when working with subcultures (immigration status, gender, political beliefs, socioeconomic status, sexual orientation, educational status, etc.). HLT 324V Week 1 Allied Health Community Media Scenario Details: The ability to communicate, interact with different cultures, and think critically is essential in the medical field. The interactive media scenario you will use for this assignment illustrates a situation that could easily arise when working in health care. To complete this assignment: 1. Go to the “Allied Health Community” media link: http://lc.gcumedia.com/hlt307v/allied-health-community/allied-health-community-v1.1.html 2. Click “Enter” to begin. 3. Click on the box that says “SCENARIOS.” 4. Click on “View Scenario” for the “Critical Decision Making for Providers.” 5. Examine how the described problem might happen in your facility and the...

Words: 2209 - Pages: 9

Premium Essay

Nurses

...Developing an Advocacy Campaign for Diabetes Emmanuel Besong Walden University Policy & Advocacy for Population Health Nursing 6050N DR. Trudy Tappan March 27, 2016 Introduction Population health is defined as the health outcomes and its distribution in a community. Population health includes policies and interventions that affect health outcomes. Diabetes is a population health issue. Data is used to trend diabetes outcome of the diabetic population (healthcatalyst.com, 2013). According to CDC (2014), 9.3% of the population of the United States of America live with diabetes. This percentage amount to 29.1 million people diagnosed or undiagnosed with diabetes. Each year approximately 200000 deaths occur in the United States of America alone. The disease is the 7th leading cause of death in the United States of America (CDC, 2014). National Data trend estimates that by the year 2050, 1 in every 3 American will have developed diabetes (CDC, 2014). The American Diabetes Association defines Diabetes mellitus as a metabolic disease caused by low insulin secretion or inaction of insulin resulting in hyperglycemia. Long term effect of diabetes mellitus results in failure of many organs, such as eyes, blood vessels, kidneys, nerves, heart disease, stroke, amputations of the legs and feet, and early death. Diabetes Mellitus can be classified type 1 and Type 2. Insulin dependent diabetes is called type 1 diabetes and it is caused by a lack of insulin due to the damage of beta cells...

Words: 1773 - Pages: 8

Premium Essay

Organization Bahvior

...ORGANIZATIONAL CULTURE ASSIGNMENT (INDIVIDUAL STUDENT ASSIGNMENT) Purpose of Assignment This assignment is designed to give students practice in applying concepts of organizational culture to a health-related work setting. Procedure 1. Read Chapter 8 from the textbook, “Comparative Health Cultures,” and the excerpt from Albrecht and Bach (1997) on “Viewing organizations as cultures” in the supplementary reading packet (Unit 7 Readings). 2. Take careful notes from the lecture “Comparative Health Cultures” (Unit 7), particularly the section addressing organizational culture. 3. Pick ONE of the following settings to address in your essay: Hospitals (public or private) Health departments (state or local) Government agencies (federal, state, local) For-profit health care organizations Private charitable organizations Educational institutions (universities, schools) 4. Write a 2-page essay according to the following directions: Using the seven indicators of organizational culture described in Albrecht and Bach (relevant constructs, facts, practices, vocabulary, metaphors, stories and rites and rituals), as well as organizational culture concepts from the text (e.g. value priorities, implicit assumptions) write a 2-page essay responding to the two questions identified in Albrecht and Bach: 1. Which of these cultural factors exist in an organization in which you are a currently...

Words: 388 - Pages: 2

Free Essay

Home Away from Home

...2007, 2006, 2005 by University of Phoenix. All rights reserved. University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries. Microsoft®, Windows®, and Windows NT® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended to imply endorsement, sponsorship, or affiliation. Edited in accordance with University of Phoenix® editorial standards and practices. Course Description This course begins a demonstration and examination of various concepts of algebra. It assists in building skills for performing specific mathematical operations and problem solving. These concepts and skills serve as a foundation for subsequent quantitative business coursework. Applications to real-world problems are emphasized throughout the course. This course is the first half of the college mathematics sequence, which is completed in MTH 209: College Mathematics II. Course Topics & Objectives Week One: Fundamentals of Expressions • Identify real and variable elements. • Classify real numbers. • Solve problems containing fractions. • Evaluate expressions. • Apply mathematical laws and order of operations principles to solve math problems. • Create expressions using real-world applications. Week Two: Linear Equations & Inequalities ...

Words: 2601 - Pages: 11

Premium Essay

Unit 1 - Individual Project - Introduction to Macroeconomic Theory

...Unit 1 - Individual Project - Introduction to Macroeconomic Theory Click Link Below To Buy: http://hwcampus.com/shop/unit-1-individual-project-introduction-macroeconomic-theory/ Assignment Details Assignment Description Weekly tasks or assignments (Individual or Group Projects) will be due by Monday and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time. In economics, they say a picture is worth a thousand words. Below, you will find two scenarios. Your assignment is to discuss the situation by writing the solutions, and then show the solutions and how you got here in one or more graphs or flowcharts. Scenario One Supply and demand are foundational concepts in understanding economic theory. Whether you are a coffee drinker or not, you have been tasked to examine the impact of supply and demand when dealing with the coffee retail industry. A few companies probably come to mind. Pick a major coffee retailer, and then contemplate what has been happening to both the supply and demand for this product. Next, analyze the following scenario that deals with what happened in the coffee industry at the beginning of the last decade: In the early part of the last decade, there was an overproduction of coffee. The price dropped so low that producers' costs were higher than the market price. The reason this happened was that market prices...

Words: 4383 - Pages: 18

Premium Essay

Unit 1 - Individual Project - Introduction to Macroeconomic Theory

...Unit 1 - Individual Project - Introduction to Macroeconomic Theory Click Link Below To Buy: http://hwcampus.com/shop/unit-1-individual-project-introduction-macroeconomic-theory/ Assignment Details Assignment Description Weekly tasks or assignments (Individual or Group Projects) will be due by Monday and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time. In economics, they say a picture is worth a thousand words. Below, you will find two scenarios. Your assignment is to discuss the situation by writing the solutions, and then show the solutions and how you got here in one or more graphs or flowcharts. Scenario One Supply and demand are foundational concepts in understanding economic theory. Whether you are a coffee drinker or not, you have been tasked to examine the impact of supply and demand when dealing with the coffee retail industry. A few companies probably come to mind. Pick a major coffee retailer, and then contemplate what has been happening to both the supply and demand for this product. Next, analyze the following scenario that deals with what happened in the coffee industry at the beginning of the last decade: In the early part of the last decade, there was an overproduction of coffee. The price dropped so low that producers' costs were higher than the market price. The reason this happened was that market prices...

Words: 4383 - Pages: 18

Premium Essay

Socksu

...process, and manage information.  Emphasis on technology based health applications which support clinical, administrative, research, and educational decision making enhancing the efficacy of nursing endeavors. Course Purpose:  This course provides an overview of nursing informatics for all student nurse.  Focus is on developing an understanding of concepts relevant to health care informatics.  Current trends and issues in using, designing, and managing heath care information systems will be examined.  Students, applying  knowledge from assigned readings, will analyze the design and implementation of health care information systems.  The course includes email, electronic discussion forums, computer applications, worldwide web, and internet assignments. Course Objectives:  1.  Identify key trends and issues in nursing informatics and the impact on health care information systems.      1.1    Describe the historical perspectives of nursing and computers      1.2    Discuss the term nursing informatics.      1.3    Define basic terms related to hardware, software, World Wide Web, and the Internet.      1.4    Identify informatics visions for the profession of nursing.      1.5    Discuss technology applications utilizing speech recognition, genomic informatics, date warehousing, and virtual reality. 2.  Explain how theories, such as communication, information, management, systems, and nursing relate to  health care information systems.      2.1    Define classic change theories: ...

Words: 2003 - Pages: 9

Premium Essay

Hlt 310v Week 2 Complete Assignment and Dq

...WEEK 2 COMPLETE ASSIGNMENT AND DQ To purchase this tutorial visit here: http://wiseamerican.us/product/hlt-310v-week-2-complete-assignment-dq/ contact us at: SUPPORT@WISEAMERICAN.US HLT 310V WEEK 2 WEEK 2 TOPIC 2 DQ 1 Refer to the GCU Introduction, The Death of Ivan Ilych by Tolstoy and the three concepts of the “healing environment” found in chapters 7-9 of Called to Care: A Christian Worldview for Nursing. What is the phenomenology of illness and disease (i.e. the personal “what it is like”)? Cite references from your reading to support your answer. What is a personal analysis of your own experience with illness and disease and how several factors colored that experience? How can you relate to The Death of Ivan Ilych? WEEK 2 TOPIC 2 DQ 2 What is the Christian concept of the imago dei? How might it be relevant to our unique approach in health care and why is it important? WEEK 2 ASSIGNMENT (BENCHMARK ASSIGNMENT) HEALING HOSPITAL: A DARING PARADIGM Max Points: 125 Details: Consider how the paradigm of a healing hospital might influence your philosophy of caregiving and write an essay of 500-750 words that addresses the following: 1. Describe the components of a healing hospital and their relationship to spirituality. 2. What are the challenges of creating a healing environment in light of the barriers and complexities of the hospital environment? 3. Include biblical aspects that support the concept of a healing hospital. Prepare this assignment according to the...

Words: 938 - Pages: 4