"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message
news:1a75df45.0312230405.42f6e481_at_posting.google.com...
> "Christian Nein" <christian_at_nein.de> wrote:
>
> > can anybody tell me how a 1:c - relation (c is a fixed number, e.g.1:0,
1:1,
> > 1:2, ..., 1:N) can be realized in Oracle?
>
> Er.. since when does the N part in 1:N not mean 1:2? Or 1:1? Or 1:2?
>
> Or did you mean 1:3? Well, N can also be 3. Here ya go. N := 3. Thus 1:N
is now 1:3.
>
> That is why it is called a 1:N relationship.
>
> N can even be c. N := c. Now 1:c is also realised.
>
> Entity relationships are either a 1:N or N:M. Show me one that is not.
You have relationships in your database designs? you lucky, lucky man
<g,d&r>
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Tue Dec 23 2003 - 06:18:01 CST
