Parent Entity Explanation

Decent Essays
Show More
Relationship: PATIENT “schedules” APPOINTMENT

Relationship type: 1:M
Explanation: business rules state, “A patient can schedule many appointments with one or more nutritionist at Vitality”. The PATIENT entity is on the “one” side of the relationship and the APPOINTMENT entity is on the “many” side of the relationship.

Relationship participation: mandatory on the “one” side of the relationship and optional on the “many” side of the relationship.
Explanation: The PATIENT entity is mandatory in the relationship because “A patient can schedule many appointments with one or more nutritionist at Vitality”. The APPOINTMENT entity is optional in the relationship because “A patient can schedule many appointments with one or more nutritionist at Vitality”, …show more content…
The primary key is APP_ID for the entity APPOINTMENT. The primary key for the parent entity PATIENT is PAT_ID. PAT_ID is considered a foreign key and not part of the primary key for APPOINTMENT.

Relationship: NUTRITIONIST “consults” APPOINTMENT

Relationship type: 1:M
Explanation: business rules state, “A nutritionist can accept appointments with many patients. Each appointment made with only 1 nutritionist”. The NUTRITIONIST entity is on the “one” side of the relationship and the APPOINTMENT entity is on the “many” side of the relationship.

Relationship participation: mandatory on the “one” side of the relationship and optional on the “many” side of the relationship.
Explanation: The NUTRITIONIST entity is mandatory in the relationship because “A nutritionist can accept appointments with many patients. Each appointment made with only 1 nutritionist”. The APPOINTMENT entity is optional in the relationship because “A nutritionist can accept appointments with many patients. Each appointment made with only 1 nutritionist”, so an appointment could not be accepted at all by a …show more content…
However each recommended nutrition plan is made with only one nutritionist for one patient at a time”. The PATIENT entity is on the “one” side of the relationship and the NUTRITION PLAN entity is on the “many” side of the relationship.

Relationship participation: mandatory on the “one” side of the relationship and optional on the “many” side of the relationship.
Explanation: The PATIENT entity is mandatory in the relationship because “The patient can receive many different nutrition plans. However each recommended nutrition plan is made with only one nutritionist for one patient at a time”. The NUTRITION PLAN entity is optional in the relationship because “However each recommended nutrition plan is made with only one nutritionist for one patient at a time”, which means an occurrence of a nutrition plan only happens if a nutritionist recommends one and if patient chooses to receive it. Cardinality: the cardinality of PATIENT is (1, 1) the cardinality of NUTRITION PLAN is (0, M)

Relationship strength:

Related Documents

  • Decent Essays

    Valley Oasis Case Study
    • 113 Words
    • 1 Pages

    Valley Oasis Case Study

    Valley Oasis, Lancaster, CA Jan. 2007 – Oct.2011 Case Manager II/Advocate Conducted over 200 field visits to sexual assault victims for major hospital for immediate trauma counseling. Developed appropriate treatment plan modality for clientele to achieve goals. Coordinated clientele plan of care with other medical and behavioral clinicians which required CRM software utilization for case studies and market strategies. Key Accomplishments  Maintained ongoing caseload over 150 of clientele with Psycho-Social Assessments to determine all necessities.…

    • 113 Words
    • 1 Pages
    Decent Essays
    Read More
  • Improved Essays

    HIPAA-Compliance Training Report
    • 108 Words
    • 1 Pages

    HIPAA-Compliance Training Report

    To avoid any legal issues when trying to contact patients to schedule appointments, the healthcare provider should develop a policy documenting the procedure with specific instructions as to what information can be left in a message and train employees to check for patient contact directives regarding who can be contacted. HIPAA Privacy Rule training, which covers the usage and disclosure of PHI, should be included in the new hire orientation training for schedulers and in the mandatory yearly compliance training. Policies and procedures for obtaining patient contact information when registering new patients and updating patient contact information for return patients should be also be included in the training.…

    • 108 Words
    • 1 Pages
    Improved Essays
    Read More
  • Improved Essays

    Case Study: Hobby Lobby Stores, Inc.
    • 1587 Words
    • 7 Pages

    Case Study: Hobby Lobby Stores, Inc.

    BURWELL, SECRETARY OF HEALTH AND HUMAN SERVICES, et al. v. HOBBY LOBBY STORES, INC., et al. Argued March 25, 2014— Decided June 30, 20141 The Religious Freedom Restoration Act of 1993 prohibits the “Government [from] substantially burden[ing] a person’s exercise of religion even if the burden results from a rule of general applicability” unless the Government “demonstrates that application of the burden to the person—(1) is in furtherance of a compelling governmental interest; and (2) is the least restrictive means of furthering that compelling governmental interest.”…

    • 1587 Words
    • 7 Pages
    Improved Essays
    Read More
  • Decent Essays

    Corrective Action Plan
    • 116 Words
    • 1 Pages

    Corrective Action Plan

    Thank you for addressing concerns regarding your appointment availability. Your Corrective Action Plan has been accepted. You have now satisfied the contractual requirement to be available within twenty-four (24) hours for an urgent appointment and within ten (10) business days (fourteen (14) calendar days) for a routine appointment. To summarize, the required appointment availability categories are as follows: emergency medical and psychiatric care: twenty-four (24) hours a day, seven (7) days a week; non-life-threatening emergencies: within six (6) hours; urgent care: within forty-eight (48) hours; and, routine appointments: within ten (10) business days.…

    • 116 Words
    • 1 Pages
    Decent Essays
    Read More
  • Superior Essays

    Sigmund Freud's Eight Stages Of Development
    • 1319 Words
    • 6 Pages

    Sigmund Freud's Eight Stages Of Development

    During every portion of life there are a number of stages that one passes through to progress and grow into the person that they are at present. While there is still room to further one’s self in adulthood, it’s usually from birth to adolescence that offers the largest span of change. Growth, in both the physical and mental sense, occurs at a rapid rate throughout these years that can alter a person significantly, however outside influences such as environment or opportunities play their part in molding youths. One’s emotions, social skills, beliefs, relationships, intelligence, and many other aspects of life are under near constant construction while in the process of developing that leaves them susceptible to change. Contained within this…

    • 1319 Words
    • 6 Pages
    Superior Essays
    Read More
  • Improved Essays

    Happy Hospital Case Study
    • 1226 Words
    • 5 Pages

    Happy Hospital Case Study

    Introduction Now a day, it have many size of hospital. But most hospital needed to improve service. Because of in this time, it have more hospital that are the competitor. Happy Healthy Hospital is one of medium size hospital that will develop to be a modern hospital. Modern hospital are the hospital that use a technology with the process of service or use to manage the system to be easy to use.…

    • 1226 Words
    • 5 Pages
    Improved Essays
    Read More
  • Improved Essays

    What Is Protected Health Information (HIPAA)?
    • 995 Words
    • 4 Pages

    What Is Protected Health Information (HIPAA)?

    What is HIPAA (#1)? HIPAA stands for “Health Insurance Portability and Accountability Act”, and it was passed by congress in 1996. The act was designed to reform healthcare in such a way that would provide protection to workers who changed or lost their jobs, ensure the confidentiality of patients medical information, and increase efficiency in the healthcare system by standardizing the processes of medical data storage and transmission (Bowers, Donna Par. 1). What is the HIPAA Privacy Rule (#2)…

    • 995 Words
    • 4 Pages
    Improved Essays
    Read More
  • Superior Essays

    Gastroparesis: A Case Study Questions For Medical Nutrition Therapy
    • 1476 Words
    • 6 Pages

    Gastroparesis: A Case Study Questions For Medical Nutrition Therapy

    b. Have patient identify foods which are higher in calories, but nutritious and follow the lower fiber, lower fat restrictions • Inadequate protein intake • Provide basic education and counseling on increasing total daily protein and have patient identify protein-rich foods (both meat and non-meat protein options) which can be included in her usual diet a. Provide education on patient’s daily needs for protein (~71 grams daily) b. Recommend to patient to eat protein foods in smaller amounts throughout the day to help decrease symptoms such as abdominal pain • Inadequate oral…

    • 1476 Words
    • 6 Pages
    Superior Essays
    Read More
  • Decent Essays

    Administrative Simplification Subsection: Case Study
    • 143 Words
    • 1 Pages

    Administrative Simplification Subsection: Case Study

    Business associate agreements apply to privacy and security components of the Administrative Simplification Subsection. There is an HIPPA Privacy Rule, as well as an HIPPA Security Rule. “The Privacy Rule allows covered providers and health plans to disclose protected health information to the business associates if the providers or plans obtain written satisfactory assurances that the associate will use the information only for the purposes for which it was engaged by the covered entity, will safeguard the information for misuse, and all help the covered entity comply with duties under the privacy rule” (Gartee, 2011, p. 57). The security rule is a safeguard under the categories of administrative, physical and technical. It is the protection…

    • 143 Words
    • 1 Pages
    Decent Essays
    Read More
  • Improved Essays

    Teach Back Methods
    • 1029 Words
    • 4 Pages

    Teach Back Methods

    The time spent between a patient and provider is indicated by provider started and provider completed on the timesheet. There is also an area labeled resident start and completed that may demonstrate when a resident or other staff not previously mentioned would make contact with a patient. Excel as well as a time and date web page was utilized to analyze the time of each area which included NP for new patient and FU for follow-up for the particular provider and day. To differentiate between morning and afternoon appointments, AM appointments were indicated by being yellow, and PM appointments were indicated by being green. The total appointment time consisted of the time of sign-in to the time they left the clinic.…

    • 1029 Words
    • 4 Pages
    Improved Essays
    Read More
  • Superior Essays

    Conflict Theory: Making Choices In Closing My Family
    • 1231 Words
    • 5 Pages

    Conflict Theory: Making Choices In Closing My Family

    Family Introduction Paper Traditionally, family is defined by the title and relationship of the ancestry. However the modern day definition has evolved to include anyone with an intimate and or both vital connections to the relationship.…

    • 1231 Words
    • 5 Pages
    Superior Essays
    Read More
  • Improved Essays

    Cpt Codes Essay
    • 444 Words
    • 2 Pages

    Cpt Codes Essay

    Discuss the difference between Level 1: CPT Codes and Level II: HCPCS National Codes and give an example of each. Level 1: CPT Codes are codes used for medical procedures, these consist of five digits. “Current Procedural Terminology (CPT), is a code set maintained by the American Medical Association (AMA)”, it is designed to describe medical, surgical, and diagnostic services accurately. It is used as a form of uniform communication across the medical field. The CPT Codes are not particularly private, as AMA has the sole copyright to the codes, so you have to “pay a license fee if you want to compare the Relative Value Unit (RVU) values to the CPT codes”.…

    • 444 Words
    • 2 Pages
    Improved Essays
    Read More
  • Superior Essays

    The Importance Of Opportunity Cost In Healthcare
    • 1081 Words
    • 5 Pages

    The Importance Of Opportunity Cost In Healthcare

    Opportunity cost is defined as what must be given up in order to do or obtain something; the highest-valued alternative that must be foregone; for example, the opportunity cost of taking the final exam may be missing out on a trip to Bermuda (Getzen, 2013). The New Oxford American Dictionary defines it as "the loss of potential gain from other alternatives when one alternative is chosen. " Opportunity cost is a key concept in economics, and has been described as expressing "the basic relationship between scarcity and choice (Buchanan, 2008). Opportunity costs play a role in decision-making to ensure that scarce resources are utilized efficiently. Opportunity cost is not only monetary or financial but can be associated with loss of time, experiences…

    • 1081 Words
    • 5 Pages
    Superior Essays
    Read More
  • Superior Essays

    Symbolic Interactionism In The Family
    • 1134 Words
    • 5 Pages
    • 5 Works Cited

    Symbolic Interactionism In The Family

    Conflict can take the form of competing goals as well as different role expectations. A working mother, for instance, wishes to split the housework in half, but her husband maintains that household chores are her responsibility and not a man’s. A family’s difference in age, sex and personalities will also contribute to the natural occurrence of…

    • 1134 Words
    • 5 Pages
    • 5 Works Cited
    Superior Essays
    Read More
  • Improved Essays

    Example Of A Relationship Analysis Essay About Relationships
    • 785 Words
    • 4 Pages

    Example Of A Relationship Analysis Essay About Relationships

    Relationship analysis Humans are by nature innately social beings and they thrive on relationships. Having Relationships and participating in social interaction are some of the basic needs of human beings. They are beneficial to people’s physical and mental health. People crave affection, respect, love, respect, and companionship. Relationships can be detrimental to a person’s health if it is bad or it can promote happiness and success.…

    • 785 Words
    • 4 Pages
    Improved Essays
    Read More

Related Topics

Ready To Get Started?
Discover
Company
Follow
©2024 Cram.com
Privacy Policy |  About Ads |  Site Map |  Advertise  | 
  • Cookie Settings