Question: In this assignment you will implement a simple Healthcare management system in which an administrator of the system can search for all appointments of a
In this assignment you will implement a simple Healthcare management system in which an administrator of the system can search for all appointments of a particular doctor. Also, the administrator could add a doctor, delete a doctor, add an appointment and delete an appointment record.
First, we want to store data about patient medical records and appointments for simplicity assume that each doctor can have many appointments and the appointment is handled by only one doctor
We want to store doctors and appointments.
Save the data for doctors and appointments in the following format: delimited fields and length indicator record.
Consider the following specifications for the fields of each record in both the doctors and appointments data files:
tableDoctors Data fileChar Doctor ID primary keyChar Doctor Name Char Address
tableAppointments Data fileChar Appointment ID primary keyChar Appointment Date Char Doctor ID secondary key
Please consider building the following indexes:
Primary index using the Doctor ID for Doctors data file
Primary index using the Appointment ID for Appointments data file
Secondary index using the Doctor ID for the Appointments data file
Secondary index using the Doctor Name for the Doctors data file
Implement add, update and delete functions. Make sure that consider the following situations in your design:
When you add a record, first look at the AVAIL LIST, then write the record. If there is a record available in the AVAIL LIST, write the record to a record AVAIL LIST points and make appropriate changes on the AVAIL LIST.
If the record to be added already exits, do not write that record to the file.
When you delete a record, do not physically delete the record from file, just put a marker on the file and make appropriate changes on AVAIL LIST.
If the record to be deleted does not exist, display a warning message on the screen.
For the update function, make updates to nonkey fields only. Also, updates to these fields will not exceed the allocated size.
Note: all add and delete operations will affect indexes.
note in need to write pmary ondex and secondary index using cas it is required from this image
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
