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 #