Design a database for the Patient Access and Registration. Some of the basic suggestions of information in this database are given below. You will need to investigate further about the typical operations in a medical setting and possibly using the above links, and design your database, and accordingly consider several base tables such as for medical staff as well as linking tables such as for patient appointments, physician schedules, nurse schedules, surgery room schedules, inpatient room schedules, and equipment reservations, as well as some look up tables such as ICD-10 codes, etc. Normalize your design into its 3rd Normal Form.

1. Patients: information about each patient, such as their name, address, contact information, date of birth, medical history, and insurance information.
2. Physicians: information about each physician who provides care at the hospital, such as their name, contact information, specialty, and licensing information.
3. Nurses: information about each nurse employed by the hospital, including name, contact information, department, job title, and hire date.
4. Notes: notes and comments made by healthcare professionals during the course of patient care.
5. Appointments: information about patient appointments, including the date and time of the appointment, the patient name, physician name, and the reason for the appointment.
6. Admissions: information about patient admissions to the hospital, including the admission date, discharge date, diagnosis, treating physician, and room number.
7. Procedures: information about medical procedures performed on patients, including the date of the procedure, the patient name, the physician performing the procedure, and any notes about the procedure.
8. Medications: information about medications prescribed to patients, including the name of the medication, dosage, frequency, and prescribing physician.
9. Lab results: information about laboratory test results, including the test name, date of the test, patient name, physician name, and the test results.
10. Billing: information about patient billing, including charges for medical services rendered, insurance information, and payment information.

Answer rating: 100% (QA)

To design a database for Patient Access and Registration in a medical setting and ensure its in 3rd Normal Form we can create the following tables Pat... View the full answer