Member Avatar for GrimJack

Is there an algorithm for normalizing data? I think I understand the process but how do I know when I have drilled down to the bottom?

  • 2 Contributors
  • 1 Reply
  • 75 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by dickersonka
Member Avatar for dickersonka

don't believe there is any algorithm for it

you know you have drilled down when you can't have one column changing data based upon another column

ie - classic example
customer
city
state
zip

you could have a zip column with one city and state, then have another city and state with the same zip which would violate it

therefor you would need to create a separate table for holding zip, city, and state

once you have eliminated all occurrences that could happen like this, then normalization is done

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.