ARC relationship
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
An ARC Relationship is an arc symbol used on a data model to indicate that two or more relationships are mutually exclusive (XOR).
Examples:
- a PERSON entity is either an EMPLOYEE or a CUSTOMER, but not both
- a BANK_ACCOUNT is either for a COMPANY or an INDIVIDUAL, but not both
- a PART can either be a NUT or BOLT or SCREW, but only one of these at a time
ARC relationships are implemented as foreign keys at database level.
Also see[edit]
Glossary of Terms | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |