how to implement normalisation?

Question

1.00/5 (1 vote)

See more:

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

Posted 16-Nov-11 17:20pm

shivani 2013

Add a Solution

Comments

Mehdi Gholam 17-Nov-11 0:01am

Normalization is dependent on your requirements for the application, it is very hard to judge with out it.

shivani 2013 17-Nov-11 0:04am

I have only this data........

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ganesan Senthilvel · Answer 1 · 2011-11-16T17:40:00

Solution 1

If you want to associate the patient with multiple hospital, then it needs to be taken care.

Posted 16-Nov-11 17:40pm

Ganesan Senthilvel