1. Home
  2. Computing & Technology
  3. Databases
Mike Chapple
Mike's Databases Blog

By Mike Chapple, About.com Guide to Databases

Third Normal Form

Sunday October 25, 2009

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!

Comments

No comments yet. Leave a Comment

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

Explore Databases
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Databases

©2009 About.com, a part of The New York Times Company.

All rights reserved.