|
The dotted
box in the top left corner shows the set of objects that are
PERSONS.
|
1
|
Primary Key column
|
|
2, 3 ...
|
Alternate (secondary) key column
|
|
FK
|
Foreign Key column
|
|
(V)
|
Virtual column: field value is derived from a different base
table (also referred to as 'joined column').
|
|
(X)
|
Exclusivity rule: each supertype can be ONLY ONE of its
subtypes.
|
|
(D)
|
Deduction: value (for RESERVATION.GROUP_DISCOUNT) is deduced
from (number of related records in the PARTICIPANT table and data
in the DISCOUNT table).
|
|
