Results 1 to 3 of 3

Thread: normalisation

  1. #1
    Join Date
    Apr 2012
    Posts
    1

    normalisation

    I just want to know, under what circumstances is it ok to use a lower normal form rather than a higher one...

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    when the circumstances of the situation warrant it

    for example, i almost always use 3NF/BCNF instead of going to 5NF (or whatever that form is that has only one data attribute per key) because i don't like needless joins
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486

    normalization

    A lower "normal form" is sometimes used for ease of use, but more often (when done correctly) it is for performance reasons.

Posting Permissions

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