Support Groups for 24-hour emergency careCalls for assistance and supportAid and Support utilizing callsBefore seeing the doctor, any new patients are first enrolled in their database. Following...

1 answer below »



Support Groups for 24-hour emergency care



Calls for assistance and support













Aid and Support utilizing calls



Before seeing the doctor, any new patients are first enrolled in their database. Following diagnosis, the



physician can update patient-related information (Including the disease diagnosed and prescription). A



facility for admitting critically ill patients is also provided by this organization. This company employs



nurses and ward boys in addition to physicians.



A doctor is assigned to every nurse and ward boy. Also, they could be given patients (to take care of



them). Patients can use cash or online banking to pay their bills. The organization also keeps a record of



each payment that has been made. Each call made to an existing individual to offer assistance and



support is recorded and kept on file.






Define the users of the system






Draw a Use-Case diagram






Define the entities and relationships






Draw the ER Diagrams






Your DB should satisfy the data needs of the organization in every aspect.






Normalization Steps






Enter a few records to test StoredProcedures, Views, etc






Optimizing Queries (indexes, etc)













Answered 14 days AfterApr 10, 2023

Answer To: Support Groups for 24-hour emergency careCalls for assistance and supportAid and Support utilizing...

Amar Kumar answered on Apr 25 2023
23 Votes
1.
The system's users would be as follows, in accordance with the scenario:
· Those in need of immediate medical attention.
· Patien
ts are receiving medical attention from doctors, nurses, and ward boys.
· Management of support and help requests by support employees.
· A member of the administrative team is in charge of adding new patients to the database, maintaining patient records, and handling payments.
2.
Medical Staff (Provide Emergency Medical Care, Update
Admin Staff (Enroll New Patients, Manage Payments)
Emergency Care System
Coordination (Admit Critically Ill Patients)
Support Staff (Manage Calls for Assistance & Support)
The diagram depicts the three main actors who make up the system: administrative staff who handle enrolment of patients and payments, medical staff who handle emergencies and update patient records, and support staff who handle incoming calls from users who need help and support. The arrows between the actors depict the many use cases and their interactions.
3.
The following entities and connections may be determined from the supplied situation:
Entities:
1. Patient: A patient who requests emergency medical attention from the system.
2. Physician: A doctor who is in charge of making diagnoses and treating patients.
3. Nurse: an expert in medicine who is in charge of treating patients as...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here