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

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

Re: BCNF: superkey or candidate key ?

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 25 Sep 2006 19:36:14 GMT
Message-ID: <OcWRg.39609$9u.334725@ursa-nb00s0.nbnet.nb.ca> 





masong_at_sbcglobal.net wrote:



> Yes it would, but the determinant in B -> X is not a candidate key, it can

> be reduced, it's a superkey.

> Maybe the answer is that considering the closure of FDs, we find that

> candidate key is too strong a term and that superkey is now accurate. 




If one added the additional constraint that B -> X is left-irreducible, 
would any proper superkeys remain to consider?
Received on Mon Sep 25 2006 - 14:36:14 CDT












Original text of this message













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