FNF, First Normal Form

    Find a general key that spans all.
  • What is that key? Which data elements make every row unique? Which values do you need to know to find one, and only one, value for all other data elements?
  • Choose a key of which the value never changes.
  • Keep the key as small as possible. Don't make it any larger than neccessary.
  • Put the key data elements in front. Underline those sticky pads.
Design in First Normal Form, a key of several columns
Those who know the tax number and the newspapername can find the rest.

You now have a very preliminary database design, with one table, where each value depends on the key.