Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: One to One Relationship
Even if 1:1 relationships are rare, they are still needed (I believe) and as
the original question asked, how are they enforced in oracle and what is
possibly the best way of enforcing them?
I realise that they can be enforced in a lot of different ways, but does oracle provide a stock standard solution as database theory requires that they exist. Also in terms of cardinality, is there a standard oracle solution?
"Frank" <fvanbortel_at_netscape.net> wrote in message
news:3E7A242F.80802_at_netscape.net...
> Bottom line of it all:
> - modeling isn't the same as implementation
> - 1:1 relationships are very rare, if not completely avoidable,
> in logical design
> - 1:1 relations can, and will be, implemented physically. More
> often than you think.
>
> Some very practical examples of 1:1 implementations were given.
> I have not seen a logical one yet (just sub- and super entities)
> in this thread (tho I do not reread the lot)
> --
> Regards, Frank van Bortel
>
Received on Thu Mar 20 2003 - 18:25:53 CST