Results 1 to 2 of 2

Thread: help me

  1. #1
    Join Date
    Oct 2003
    Location
    uk
    Posts
    12

    help me

    hi, can anyone tell me why 3nf/bcnf is a suitable stage to conclude normalisation process, as opposed to 4th and 5th??

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: help me

    Originally posted by mercer876
    hi, can anyone tell me why 3nf/bcnf is a suitable stage to conclude normalisation process, as opposed to 4th and 5th??
    4th and 5th deal with issues that simply don't arise in 99% of tables. Of course, when those issues do arise, further normalisation should be considered. So if you only normalise to 3NF, chances are all your tables are good; whereas if you stopped at 1NF or 2NF they almost certainly would not be.

Posting Permissions

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