Re: 4NF and 5NF
From: -CELKO- <jcelko212_at_earthlink.net>
Date: 5 Jan 2005 07:13:51 -0800
Message-ID: <1104938031.440219.47710_at_f14g2000cwb.googlegroups.com>
Date: 5 Jan 2005 07:13:51 -0800
Message-ID: <1104938031.440219.47710_at_f14g2000cwb.googlegroups.com>
The only rule I know for seeing 5NF at a glance is that if the table is 3NF and all candidate keys are simple (one column), then you have 5NF. Ron Fagin proved that years ago and Chris date wrote it up in his old column in DBP&D under the title "Theory is Practical!" in 1992. Received on Wed Jan 05 2005 - 16:13:51 CET