Q1:-Perform normalisation on the following data and design it in mysql?
PatientName, PatientNumber, PatientCondition, DoctorRegistration, PatientSignin, PatientSignout, DoctorRDO, Hospital Name, Hospital Address, Outpatients, NumStaff, NumBeds, DoctorName, AssignedDoctor
i performed this
please correct if i am wrong
1st Normalisation<</b>/big>
Hospital Table
Hospital_Name
Hospital_Address
NumStaff
NumBeds
DoctorRDO
Outpatients
Doctor_Registration
Doctor_Name
Patient Table
DoctorRDO
Patient_Number
Patient_Name
Patient_Condition
PatientSignin
PatientSignout
Assigned_Doctor
2nd Normalisation
Hospital_Details Table
Hospital_Name
Hospital_Address
NumStaff
NumBeds
Outpatients
Hospital_Address is primary key
Patient Table
DoctorRDO
Patient_Number
Patient_Name
Patient_Condition
PatientSignin
PatientSignout
Assigned_Doctor
Here, Patient_Number is primary key and DoctorRDO is foreign key
Doctor_Details Table
DoctorRegistration
DoctorRDO
DoctorName
Here, Patient_ Number is foreign key and DoctorRDO is primary key
3rd Normalisation
Hospital_Details Table
Hospital_Name
Hospital_Address
NumStaff
NumBeds
Outpatients
Patient Table
DoctorRDO
Patient_Number
Patient_Name
Patient_Condition
PatientSignin
PatientSignout
Here, Patient_Number is primary key and DoctorRDO is foreign key
Doctor_Details Table
DoctorRegistration
DoctorRDO
DoctorName
Assigned_Doctor_Details Table
DoctorRDO
Patient_Number
Thanks in advance
regards