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 08:29:25 -0700
Message-ID: <1159716565.147259.167170@i42g2000cwa.googlegroups.com>

vc schreef:

> Jan Hidders wrote:
> > Marshall wrote:
> [...]
> >
> > > Is it possible to have a functional dependency that will constrain
> > > R to *exactly* one row?
> [...]
> > > If it can't be done with an FD, can we do it with a constraint?
> >
> > Of course. In first-order logic you can specify this (i.e. that there
> > is at least one tuple in the relation) with a simple existential
> > statement.
>
> What simple existential statement do you have in mind ?

Come on, Val! You did read between the brackets, did you? :-)

Received on Sun Oct 01 2006 - 10:29:25 CDT

Original text of this message

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