A Normalization Primer

  • K. Brian Kelley

    SSC Guru

    Points: 114445

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/normalization.asp

    K. Brian Kelley
    @kbriankelley

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714080

    Brian,

    nice introductary article. I'd love to see a followup dealing with more complex designs and including child tables.

    Steve Jones

    steve@dkranch.net

  • K. Brian Kelley

    SSC Guru

    Points: 114445

    That is something I plan on doing. This first article was to solve the question of, "What do I give the developers?!?"

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • Robert W Marda

    SSChampion

    Points: 13413

    I liked your article too. I always hear database people talk about normalization and denormalization and the various levels of normalization without really understanding what they are talking about. Now I understand this better and will understand when I hear it again. Thanks!

    Robert Marda

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • jrobertsteg

    SSC Veteran

    Points: 286

    I didn't find this to be very well-written. I gave up on it after seeing repeating data conflated with redundancy and seeing 2NF described as "all attributes describing the entire key".

  • mdhealy

    SSC Rookie

    Points: 26

    Good article but as Steve said it is indroductary. If you've got developers who don't understand normal forms you've got bigger problems on your hand.

  • K. Brian Kelley

    SSC Guru

    Points: 114445

    Hi jrobertsteg,

    Can you elaborate more on your concerns and perhaps discuss how you'd present it?

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • K. Brian Kelley

    SSC Guru

    Points: 114445

    mdhealy, I'd agree with you, but unfortunately, it's the reality of the situation. I've been in the position where I've said, "I would prefer you build your database this way..." (DBAs didn't have veto) and when asked why I said, "Normalization!" That's when I got the blank stare.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • philcart

    SSC-Forever

    Points: 47713

    I'd like to see a follow up article from the other side of the fence. De-normalizing the databaase for datawarehousing/reporting.

    In my current contract, where we are building a small datamart, I've run up against a lot of resistance to denormalizing the database.

    We've been able to alleviate some concerns by keeping the tables somewhat normalized and denormalizing via indexed views, but we still get a lot of weird looks.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • K. Brian Kelley

    SSC Guru

    Points: 114445

    That's a good idea. I'll have to add it to the list of articles I need to write. Of course, if someone is a hardcore data warehousing DBA (I know you guys are out there) write up an article and submit it to Steve, Andy, or Brian Knight!

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • G.R.Prithiviraj Kulasingham

    SSCarpal Tunnel

    Points: 4104

    Good article.

    Some more things could be elaborated more.

    Surrogate key is another issue.

    Why we need another key, etc. may be another very usefull

    Preethi

    G.R. Preethiviraj Kulasingham

    Cheers,
    Prithiviraj Kulasingham

    http://preethiviraj.blogspot.com/

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply