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)