Implementation of Normalization in SQL Server

  • Comments posted to this topic are about the item Implementation of Normalization in SQL Server

  • Since you are illustrating your process using a physical database, I think it would be instructive to include primary and foreign keys on your normalized tables to enforce your normalization.  Also, some queries joining your normalized tables could be presented to show that the data can be returned to look like the original, denormalized table.

    Using surrogate keys to present normalization is kind of awkward since normalization rules apply to natural keys.

  • hmbacon wrote:

    Using surrogate keys to present normalization is kind of awkward since normalization rules apply to natural keys.

    I wouldn't mind an illustration why tables with surrogate keys can't be subjected to normalization rules. Would be interesting to see, hoping for a reply on this!

     

  • Good article.  One critique.  You use of abbreviations in the object names made this difficult to follow.  dname?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

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

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