S
Saint Stephen
Learning ORM for my 70-300 test.
It seems to me that ORM constraints contain unnecessary symbollogy.
This is the way I understand it (ignoring symmetrical pictures):
1. (no constraint stated)
----- -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
2. (zero or more ... zero or more)
----- <-----> -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
3. (zero or one ... zero or more)
----- <-> -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
4. (exactly one ... zero or more)
----- <-> -----
| | ------- | |
| A X----| | |----| B |
| | ------- | |
----- -----
5. (one or more ... zero or more)
----- -----
| | ------- | |
| A X----| | |----X B |
| | ------- | |
----- -----
First of all, do I understand the symbollogy correctly.
An "inner arrow" (> in the middle [#3], not on the far right [#2]) is
drawn when "one" appears in the second term (uniqueness)
(shown in #3 and #4).
A "dot" (X) is drawn when "one" appears in the first term
(mandatoriness) (shown in #4 and #5).
The Outer arrows and rays appear to be use haphazardly and
inconsistently, and convey no information. I would simplify
the diagrams thusly:
1b. (no constraint stated)
----- -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
2b. (zero or more ... zero or more)
----- -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
3b. (zero or one ... zero or more)
----- > -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
4b. (exactly one ... zero or more)
----- > -----
| | ------- | |
| A X----| | |----| B |
| | ------- | |
----- -----
5b. (one or more ... zero or more)
----- -----
| | ------- | |
| A X----| | |----X B |
| | ------- | |
----- -----
I see no point in distinguishing between #1 and #2 at all.
And none of my diagrams contain any less information that
the "accepted forms."
What do you think? Am I misunderstanding them? If I am,
please correct my ignorance.
It seems to me that ORM constraints contain unnecessary symbollogy.
This is the way I understand it (ignoring symmetrical pictures):
1. (no constraint stated)
----- -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
2. (zero or more ... zero or more)
----- <-----> -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
3. (zero or one ... zero or more)
----- <-> -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
4. (exactly one ... zero or more)
----- <-> -----
| | ------- | |
| A X----| | |----| B |
| | ------- | |
----- -----
5. (one or more ... zero or more)
----- -----
| | ------- | |
| A X----| | |----X B |
| | ------- | |
----- -----
First of all, do I understand the symbollogy correctly.
An "inner arrow" (> in the middle [#3], not on the far right [#2]) is
drawn when "one" appears in the second term (uniqueness)
(shown in #3 and #4).
A "dot" (X) is drawn when "one" appears in the first term
(mandatoriness) (shown in #4 and #5).
The Outer arrows and rays appear to be use haphazardly and
inconsistently, and convey no information. I would simplify
the diagrams thusly:
1b. (no constraint stated)
----- -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
2b. (zero or more ... zero or more)
----- -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
3b. (zero or one ... zero or more)
----- > -----
| | ------- | |
| A |----| | |----| B |
| | ------- | |
----- -----
4b. (exactly one ... zero or more)
----- > -----
| | ------- | |
| A X----| | |----| B |
| | ------- | |
----- -----
5b. (one or more ... zero or more)
----- -----
| | ------- | |
| A X----| | |----X B |
| | ------- | |
----- -----
I see no point in distinguishing between #1 and #2 at all.
And none of my diagrams contain any less information that
the "accepted forms."
What do you think? Am I misunderstanding them? If I am,
please correct my ignorance.