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: Functional Dependency to constrain a relation to exactly one element?

Re: Functional Dependency to constrain a relation to exactly one element?

From: Jan Hidders <hidders_at_gmail.com>
Date: 1 Oct 2006 13:18:43 -0700
Message-ID: <1159733922.962228.215160@e3g2000cwe.googlegroups.com>

J M Davitt schreef:

>
> First question: does the empty relation satisfy all INDs, too?

Since INDs usually hold between different relations it is more appropriate to ask whether the empty database satisfies all INDs. The anser is yes.

And in case you wondered, yes, the empty relation satisfies also all MVDs and JDs.

Received on Sun Oct 01 2006 - 15:18:43 CDT

Original text of this message

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