data normalisation UNF to 1NF
Date: 27 Jan 2003 15:39:21 -0800
Message-ID: <54f867ea.0301271539.79971a1f_at_posting.google.com>
i am new to database design and have a medical record database to design.I have a problem with a particular set of attributes in that i think i will always have a repeating field at 1NF and i am not sure how to eliminate this. i have omitted most of the attributes for clarity.
Patient_ID is the primary key with all the other attributes related to this e.g address, dateofbirth, weight etc.
Med_history_type will be a drop down list for the doctor to choose an option e.g hospitalisation, accidents, X_ray. After making the choice the reason, date,results and notes will be entered.
The same will happen with Med_current_type with a drop down list choice of cardiovascular, respiratory, neurological etc being picked and then notes added.
The problem i have is that if the doctor picks hospitalisation and fills in the details and then chooses accidents and fills in the details, this makes Med_history_type a repeating field still in 1NF
I tried this and still think that Med_history_type is repeating field
UNF 1NF PatientID (PK) PatientID (PK)Med_current_type (CK) Med_current_notes
" "
" "
Med_history_type Med_history_reason Med_history_date PatientID (PK) Med_history_results Med_history_type (CK) Med_history_notes Med_history_date (CK) Med_current_type Med_history_reason Med_current_notes Med_history_results Med_history_notes PatientID (PK)
Hope this makes sense and someone can help me
johnk Received on Tue Jan 28 2003 - 00:39:21 CET