Newbie - what's all this BCNF stuff anyway?
From: Seth Brewer <fieury_at_hotmail.com>
Date: Mon, 18 Nov 2002 20:57:17 GMT
Message-ID: <NucC9.78328$1O2.5742_at_sccrnsc04>
Hi, I've been putting together some relational DBs for use in small websites. Some of these DBs even got kinda complex. After I built a few and implemented successful applications driven by them, I began thinking I was the man. Then I found this newsgroup.
Date: Mon, 18 Nov 2002 20:57:17 GMT
Message-ID: <NucC9.78328$1O2.5742_at_sccrnsc04>
Hi, I've been putting together some relational DBs for use in small websites. Some of these DBs even got kinda complex. After I built a few and implemented successful applications driven by them, I began thinking I was the man. Then I found this newsgroup.
So, please excuse my ignorance, but I'm seeing all these recent posts about BCNF and 3nf, and I'm all confused. My question is: why BCNF? I thought 3nf (or 4nf, or 5nf) was the ultimate goal. I've been assigning auto-increment primary keys like crazy in every table I've created and using them for all relationships. What's the practical (or real-world) application of BCNF over 3nf?
Humble thanks,
Seth
Received on Mon Nov 18 2002 - 21:57:17 CET