Normalize upto 3NF. This organization provides following functionalitiesEmergency Care 24x7• Support Groups• Support and Help Through callsAny new Patient is first registered in their database before meeting the doctor. Each Doctor haveID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctorcan update the data related to the patient upon diagnosis (Including the disease diagnosed andprescription).doctor examined number of patients on daily bases. Patient has unique id, name,age, gender, disease status (admitted, discharged, expired), date and address. Patients withcritical condition are examined by many doctors. This organization also provides rooms facilityfor admitting the patient who is critical. One room can be booked by one patient only and eachroom has room#, location attributes. Apart from doctors, this organization has nurses and wardboy. Each nurse and ward boy is assigned to a doctor. Also, they can be assigned to patients (totake care of them). One nurse can be assigned to no of patients. The bill is paid by the patientwith cash and E-banking. Record of each payment made is also maintained by the organization.The record of each call received to provide help and support to its existing person is alsomaintained. Each doctor's record is maintained by organization and no of patient examined by adoctor can be calculated. Organization also keeps record of expiries and no of expired patientscan be calculated.

Answered: Image /qna-images/answer/7f9308ca-4397-4529-9c29-213e36854a39.jpg

This organization provides following functionalities Emergency Care 24x7 Support Groups Support and Help Through calls Any new Patient is first registered in their database before meeting the doctor, Each Doctor have ID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctor can update the data related to the patient upon diagnosis (Including the disease diagnosed and prescription).doctor examined number of patients on daily bases. Patient has unique id, name, age, gender, disease status (admitted, discharged, expired), date and address. Patients with critical condition are examined by many doctors. This organization also provides rooms facility