i will make db for
The hospital patient database contains the following information:
1. The information of each patient such as name, address, phone, insurance info.
2. The information of each Doctor, such as name, employee ID, position, degree, affiliated department in the hospital.
3. The information of each Nurse, such as name, employee ID, position, degree, affiliated department in the hospital.
4. The information of each department in the hospital such as department name, and manager.
5. The information of each appointment, such as Patient, start time, doctor, nurse, and symptom of the patient.
6. The information of medication, such as name, brand, description, doses, and for which appointment.
7. The information of lab tests, such as test name, test result, date and time the test is performed, location/clinic the test is performed, and the appointment from which the test is requested.