Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> BCNF: superkey or candidate key ?

BCNF: superkey or candidate key ?

From: <masong_at_sbcglobal.net>
Date: Thu, 21 Sep 2006 11:33:33 GMT
Message-ID: <1158838496_4271@sp6iad.superfeed.net>


C.J. Date in a recent text defines BCNF in terms of superkey. ... every nontrivial FD A -> B satisfied by R, A is a superkey for R.

Previously he (and others) defined it where A had to be a candidate key (which is irreducible).

The two are not equivalent. The prior definition was more strict. What is the accepted definition du jour ? And what motivated the change ?

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Received on Thu Sep 21 2006 - 06:33:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US