Public Health Management System: ER Diagrams and Relational Models

Solution Code: 1AGE

Question: Advanced Accounting Report

This assignment is related to " Public Health Management System" and experts at Grade Saviours successfully delivered HD quality work within the given deadline.

Public Health Management System

Task Details:

Introduction

This assignment will help you evaluate your skills and also deepen your skills in designing a database (Conceptual and Logical Model) using business rules. You need to apply your skills in designing ER Diagrams and Relational Models.

Assignment Details

Part 1 Database Design Please design a relational database for the following scenario using the ER diagrams and relational modelling techniques taught in classes and tutorials.

Scenario

NewTowny city council would like to create a database for their public healthcare system so that data can be managed, retrieved and updated easily. NewTowny has one public hospital which supports for health needs of all the residents. The city council provided following business rules: Everyday hospital handles several patients and hosts several doctors (General practitionersand Specialists). The hospital has two department: General and Emergency. Each patient needs to be registered before he can be admitted to the hospital. During registration, several personal details of the patients are collected such as patient name, address, current medication, information about chronic disease, known allergies, and NewTowny resident identification number. During registration they are assigned to General practitioner with whom he can make one or more appointments. The patient should first make appointment with his general practitioner for any health issue unless it is an emergency which are handled by emergency department. Each appointment contains details such as time and venue including the communication medium using which the appointment is made. Appointments can be made by email, phone or in person. If kept, an appointment yields a visit with the general practitioner specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. A diagnosis may contain tests prescribed, result of tests and doctors comments. A treatment generally constitute the time duration of treatment (i.e. start and end date), diet plan as a blob of text, and prescribed medicines as a blob of text. General practitioner can refer the patient to one or more specialists with whom patient can make one or more appointments. However, Specialist can accept the appointments only if a patient got a reference from a general practitioner. Emergency cases do not require an appointment, however the details are entered in the patient record. During emergency, a patient’s situation is diagnosed by a general practitioner and then by a specialist who gives a treatment accordingly. Each patient visit creates a bill which contains information such as date of the visit, particular doctor’s fees, and service charge. If appointment is not kept, the patient will be billed a cancelation fee. Each bill must be paid. However, a bill may be paid off in many installment payments, and a payment may cover more than one bill. A patient may pay the bill directly, or the bill may be the basis for a claim submitted to an insurance company. If the bill is paid by an insurance company, the deductible is submitted to the patient for payment.

Steps in Design (HINT)

Design an Entity Relationship Diagram using conventions taught in tutorial
- Identify the entities, attributes, relationships, participation and cardinality
- Show to your tutor to get comments.
Design a relational model by using conversion algorithm taught during tutorial

Submission You are expected to submit a word document which details the following:

Your Name and Student id on the first page.
An Entity Relationship diagram modelling the scenario using the ER conventions for KIT102 (given in your tutorial handout). This can be drawn on a sheet of paper, then scanned.
A Relational Model with all the conversion steps involved in converting from the ER diagram to the Relational model (Using the conventions given during tutorial).
All submissions will be via MyLO.

If you do not understand file submission instructions, seek help from your tutor or your lecturer at least one day before the assignment is due. Please work on the assignment before the due date, do not wait till last moment to submit your assessment.

These assignments are solved by our professional Nursing Assignment Experts at Grade Saviours and the solution are high quality of work as well as 100% plagiarism free. The assignment solution was delivered within 2-3 Days. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Solution:Public Health Management System

Entity Description

Entity Name	Description
Doctor	The table will contain all the details of the doctor, which includes there name, address, speciality, etc
Department	The department table will contain all the enteries of department persisting in the hospital
Patient	The patient table will contain all the details of the patient after his/her registration
Appointment	The appointment table will contain all the details of appointment schedule for patient with doctors
Diagnosis	The diagnosis table will contain all the details of the disease diagnosed by the general ward doctor
Treatment	The treatment table will contain all the details of the suitable treatment and prescription for patient by the particular doctor
Billing	The billing table will contain all the details of payment activity done by patient for his/her appointment, test and treatment
BillingMode	The billing mode table will contain all the details of mode of billing either directly or through the insurance

Doctor
DoctorID	A unique identification for a doctor
DepartmentID	A unique identification for a department
DoctorName	The name of the doctor
Speciality	Describe the field of doctor in which he/she will be specialist
Designation	Describe the designation/degree/education of the doctor
OfficeSchedule	Describe the office schedule timing of the doctor
Gender	Describe the gender of the doctor
Fee	Describe the fee of the doctor to be paid by the patient

Patient
PatientID	A unique identification for a patient
PatientName	The name of the patient
DepartmentNeeded	The department required by patient based on the disease
Address	The address of the patient
CurrentMedication	The current medication patient is taking
ChronicDiseaseInfo	The chronic disease which patient is suffering
KnownAllergies	The things patient is allergic to
ResidentID	The resident ID of the patient
Appointment
AppointmentID	A unique identification for appointment
Date	The date for the appointment scheduled for the patient
Time	The time for the appointment scheduled for the patient
Venue	The venue assigned for the appointment
DepartmentName	The department name of the patient appointed to
DoctorID	For retrieving doctor name patient is appointed to
ModeOfCommunication	The communication (email, phone, in person) is used for booking appointment
Department
DepartmentID	A unique identification for all department
DepartmentName	The name of the department in the hospital
Diagnosis
DiagnosisID	A unique identification for diagnosed disease
PrescribedID	For retrieving prescription by doctor
TestResult	The result of the medical test done on patient
DoctorComment	The comment of the doctor based on the result
Treatment
TreatmentID	A unique identification for treatment field
StartDate	The starting date of treatment
EndDate	The ending date of the treatment
DietPlan	The diet plan assigned to patient by doctor
DoctorName	The specific doctor name assigned to specific patient
Billing
BillingID	A unique identification for billing field
VisitDate	The date of visit done by the patient
Fee	The fee to be paid by the patient for the treatment
ServiceCharge	The service charge applicable for the patient
CancellationFee	The cancellation will be applicable if patient cancel his/her appointment
BillingMode	The mode of billing decided by the patient to pay the fee
BillingMode
BillingModeID	A unique identification for BillingMode field
BillingType	The type of billing chosen by the patient (either by insurance or directly)

Find Solution for Nursing assignment by dropping us a mail at help@gradesaviours.com along with the question’s URL. Get in Contact with our experts at Grade Saviours and get the solution as per your specification & University requirement.

Hey MAS, I need Assignment Sample of

Looking For Complete Assignment Sample

Get It On WhatsApp