2NF and 3NF obsolete ???

From: Frederic <frederic_guerin_at_yahoo.com>
Date: 9 Nov 2001 06:40:07 -0800
Message-ID: <2e9d2c40.0111090640.724bb649_at_posting.google.com>

I'm preparing a course on normalisation and normal forms. I am actually consulting a book from Thomas Connolly et al. where it is stated that a table is in BCNF iff:

  Every determinant of the table is a candidate key.

Well, I guess the table may also need to be in 1NF even if the authors do not mention it. Anyway this is not the point of my message.

What strikes me is that it is very straitforward to verify this condition and also very easy to normalize afterward.

Why bother anymore with 2NF and 3NF ?

Frederic Received on Fri Nov 09 2001 - 15:40:07 CET