1-n relationship

Question

I dont get 1-n relationship.

I have read some articles but still cant figure it out.

I get 1-many, 1:1 and many-to-many.

But what does 1-n mean?

Wow. Three almost identical answers! – Lucas Jones Dec 14 '09 at 19:56 — Lucas Jones, Dec 14 '09 at 19:56

score 9 · Accepted Answer · answered Dec 14 '09 at 19:56

9

1-n is the same as 1-many

answered Dec 14 '09 at 19:56

Chris Haas

53,986
12
141
274

score 2 · Answer 2 · answered Dec 14 '09 at 19:56

2

1-n is the same as 1-many. n is just another way of representing an unknown "many".

answered Dec 14 '09 at 19:56

Lucas Jones

19,767
8
75
88

score 2 · Answer 3 · answered Dec 14 '09 at 19:56

2

n could be any number, so this is equivalent to 1:many

answered Dec 14 '09 at 19:56

Marek Karbarz

28,956
6
53
73

score 2 · Answer 4 · answered Dec 14 '09 at 19:56

2

Its just another way to say 1 to many

answered Dec 14 '09 at 19:56

Jammin

3,050
2
23
34

score 0 · Answer 5 · answered Dec 14 '09 at 20:05

0

It's another way of expressing a "parent-child" or "master-detail" relationship. For everything parent you have an undefined number (meaning it can lie between 1 and something-bigger-than-one) of children.

answered Dec 14 '09 at 20:05

davek

22,499
9
75
95

that's a misleading way of thinking of it. there's a 1:N relationship between `S` and `SP`, yet neither is child or detail of the other. – just somebody Dec 14 '09 at 20:19

1-n relationship

5 Answers5