| Design of database. [message #20718] |
Fri, 14 June 2002 20:40  |
karunamoorthy_p
Messages: 13
Registered: April 2002
|
Junior Member |
|
|
I have designed a table with the following attributes:
patient_number
patient_name
patient_address
visit_date_to_clinic(for each visit)
medicines_given(at each visit)
attending_doctors_name
amount_charged(for each visit)
age_of_patient
blood_group
What is wrong in this design?
Using normalisation how to improve the design?
|
|
|
|
| Re: Design of database. [message #20747 is a reply to message #20718] |
Mon, 17 June 2002 14:33  |
techie
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Have three tables as follows:
Table 1 (patient#, Name, DOB, Address, Blood Group)
Table 2 (Visit#, patient#, date_of_visit, doctor_name, amount)
Table 3 (Serial ID, Visit#, Medicine_name)
This design is both optimal and also flexible.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
