SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Normalization...

    ...so do you?

    Doh, I was supposed to add a poll to this, but I forgot.

    Well, anyway.

    Do you take it to the standard 3rd Boyce-Cobb Normal Form? Or go all the way?!

    Personally, I try and take it all the way to Domain-Key if I can during the logical design phase, but generally it denormalizes to the 3rd Normal Form when it actually comes down to planning and building the actual schema.

    It does take a little longer, but I like doing it, and it help me keep on top of everything as I go into developing the ASP. Also helps keep on top of those rules!!!
    Last edited by dhtmlgod; Feb 5, 2002 at 21:06.

  2. #2
    SitePoint Addict DevilBear's Avatar
    Join Date
    Oct 2001
    Location
    Hades
    Posts
    301
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You are crazy.



    I don't know that many people are familiar with normalization, especially formally. I do it the best I can, but not very rigorously.

  3. #3
    Don't get too close, I bite! Nicky's Avatar
    Join Date
    Jul 1999
    Location
    Lancashire, UK
    Posts
    8,277
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    D is right, you should normalise all your data to the third form. It is difficult at first but gets easier with practice. Not only is it professional to normalise, but it really saves a lot of hassle later as a lot of problems can arise it the normalisation stages are not followed. If you don't know anything about it read a book. I reccomend
    Database Systems by John Jones

  4. #4
    SitePoint Guru siphilp's Avatar
    Join Date
    Nov 2001
    Location
    Fife, Scotland
    Posts
    663
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey Nicky just noticed your new avatar.
    NICE



    Si
    Last edited by siphilp; Feb 6, 2002 at 07:41.

  5. #5
    Don't get too close, I bite! Nicky's Avatar
    Join Date
    Jul 1999
    Location
    Lancashire, UK
    Posts
    8,277
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Thanks, it's not new though, it is old!

  6. #6
    SitePoint Guru siphilp's Avatar
    Join Date
    Nov 2001
    Location
    Fife, Scotland
    Posts
    663
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Who says that I am actually talking about the avatar itself and not the lady on it


    Si

  7. #7
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Strange... Si's post has been edited

  8. #8
    SitePoint Guru siphilp's Avatar
    Join Date
    Nov 2001
    Location
    Fife, Scotland
    Posts
    663
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah saw a mistake in my posting (honestly)


    Si


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •