Home Forums SQLServerCentral.com Articles Requested Normal Forms RE: Normal Forms

  • April 29, 2011 at 7:12 pm

    #1318023

    Steve Jones - SSC Editor (4/28/2011)

    OK, I hesitate to ask this, but I would like to round this out.

    I am looking for a basic set of articles that explains first, second, third, maybe more, normal forms. Not like the argument going on in the Relational Theory, not from a high academic, this is correct, Date v Codd.

    I am looking for a basic explanation of what the normal forms mean from a practical perspective. Take a couple of simple tables and break them down to be normalized. Something like this, perhaps by working backwards in AdventureWorks or building a simple Order/Sales set of tables.

    http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

    You must be a glutton for punishment. 😀 What are you going to ask for next? An article that justifies why NULLs should be removed from all database systems? :hehe:

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)