Third Normal Form
In a recent forum message, Wolfman wrote:
"We have a large form based application. The form has several sections which the user fills in and they have a vast amount of information on each section, around 150 items of char, numbers and text. These sections are always read/written as a block.
If I have a table- FormSection2Physical which contains 150 columns which describe each of the questions on the form is this a violation of normalization in any way?
We also have a doctor invoice:
id, doctor_id, location_id, diagnosis1, diagnosis2, diagnosis3, patient_charge, amount, location_different (boolean)
Are there any issues here?"
Can you help Wolfman? Interested in answers to the same question? Visit the About Databases forum and join the discussion!


No comments yet. Leave a Comment