1:1 is onetoone which makes sense
1:N is onetomany, 1:M would make more sense but I'm guessing the N is similar to 'nth term' in mathematics
M:N is manytomany LOL WUT, why isn't it N:N, or M:M
Why does N:M mean a manytomany relationship?
Page 1 of 16 Replies  1838 Views  Last Post: 26 April 2012  12:38 PM
Replies To: Why does N:M mean a manytomany relationship?
#2
Re: Why does N:M mean a manytomany relationship?
Posted 26 April 2012  11:43 AM
It's to show that the left and right sides do not have to be the same number. If you said "N:N" I would assume that has to be "2:2".. or "69:69"... now when you show me to different variable names I know they do NOT have to be the same... "40:42".. or "101:101"...
#3
Re: Why does N:M mean a manytomany relationship?
Posted 26 April 2012  11:47 AM
modi123_1, on 26 April 2012  11:43 AM, said:
It's to show that the left and right sides do not have to be the same number. If you said "N:N" I would assume that has to be "2:2".. or "69:69"... now when you show me to different variable names I know they do NOT have to be the same... "40:42".. or "101:101"...
I see. So it could be X:Y or A:B either?
Would make far more sense for manytomany to be represented as M:M and onetomany to be 1:M really.
#4
Re: Why does N:M mean a manytomany relationship?
Posted 26 April 2012  11:57 AM
Quote
I see. So it could be X:Y or A:B either?
In theory yes, but M and N are the commonly used notations so I would suggest sticking with it.
Quote
Would make far more sense for manytomany to be represented as M:M
Again  no, it would not. That would imply both sides have to be the same number and that is patently not true. Break yourself of thinking of variables having to link up to some word.. they are a construct to quickly, and in a succinct short hand, represent the fuzzy idea of "any number of things". What if "many" meant a glaring of cats? Wouldn't that instance make sense to have 'G' or 'C'? You have to be more abstract.
Quote
and onetomany to be 1:M really.
Again  stop trying press some connection to the word many. What about the Germans? 'many' roughly translates to viele. The French  beaucoup. The Dutch  veel. See not everyone has the same words so everyone agrees in abstract terms are just that and not what you are familiar with!
#5
Re: Why does N:M mean a manytomany relationship?
Posted 26 April 2012  11:59 AM
There's always some reasoning to a design choice, even if it looks like wonky reasoning.
While I don't know for sure, if I were to guess, I'd say the M:N is because those variable names are preferred when describing the size of a matrix. Depending on your discipline, the pair might come readily to mind.
While I don't know for sure, if I were to guess, I'd say the M:N is because those variable names are preferred when describing the size of a matrix. Depending on your discipline, the pair might come readily to mind.
#6
Re: Why does N:M mean a manytomany relationship?
Posted 26 April 2012  12:25 PM
Rather than using "many" think of M and N as normal variables. They can be any number (or representation), we just don't know which for the particular case so we choose to represent them with an abstract variable.
When you see an equation that says y = 2x, you don't read it as "many equals 2 times many". You understand that the variables x and y are variables (commonly used for coordinates) that we don't know, but we do know the relationship between them.
The same concept applies to your problem.
When you see an equation that says y = 2x, you don't read it as "many equals 2 times many". You understand that the variables x and y are variables (commonly used for coordinates) that we don't know, but we do know the relationship between them.
The same concept applies to your problem.
This post has been edited by SpartanGuy07: 26 April 2012  12:28 PM
#7
Re: Why does N:M mean a manytomany relationship?
Posted 26 April 2012  12:38 PM
Saying the same thing yet another way,
1:1 means exactly one item relates to exactly one item.
1:2 means exactly one item relates to exactly two items (we don't see this very often)
1:N means exactly one item relates to exactly N items where N is some particular number which we don't know right at the moment or choose to leave unspecified.
N:N means a relationship of N items to N items  a square matrix. (Again, one we don't see a lot of.)
So I'll leave this one for you:
M:N means what?
1:1 means exactly one item relates to exactly one item.
1:2 means exactly one item relates to exactly two items (we don't see this very often)
1:N means exactly one item relates to exactly N items where N is some particular number which we don't know right at the moment or choose to leave unspecified.
N:N means a relationship of N items to N items  a square matrix. (Again, one we don't see a lot of.)
So I'll leave this one for you:
M:N means what?
Page 1 of 1
