2002年12月16日 | RULES FOR (R) [ EVENT-EVENT ] | BACK >> 目次 |
● (R) in the combination between "event and event" The "event" entities are the ordered pair in "time sequence" (in historical order) with the time-stamp of "DATE".
So, the identifier is, as a rule, replicated from the preceding event into the event in back bench--according to the sequence in which the events occurred, as in;
RULE:
There is an exception to the rule.
The example shows that a "bill" has a relationship to many "orders" as in a payment in a lump sum. If the identifier of "order" is replicated into the "bill", the "bill" consists of many records, of the same numbers of "order" records--but a bill is one transaction, not a "header" data for many "detail" transactions, a bill requires no itemization of amounts, it has one and only one amount. In response to "many-valued" function, the rule mentioned above shall be subdivided into two headings:
(1) in the relationship of "one-to-one" and "one-to-many",
(2) In the relationship of "many-to-one" and "many-to-many",
order: (order-NO, order-date,...) A "mapping-list" is called "taiou-hyo", that sounds like "tie-oh-he-yo".
Take an example: |
<< もどる | HOME | すすむ >> | |
T字形ER手法の英訳 |