pkb contents > uml | just under 173 words | updated 05/21/2017
UML is a graphical higher-level language used for database modeling and software design; see notes on modeling.
Analogous to relations/tables.
In/complete and disjoint/overlapping.
Inherit attributes from super/parent class, but have own unique attributes and/or unique associations.
Captures relationships between objects of two classes. Self-association is possible.
Objects in one class ‘belong’ to objects in another class. Denoted with a solid diamond on the association. Default multiplicity
1..1
. PK not required.
Objects might ‘belong’ to, at most, one object of another class. Denoted with an empty diamond on the association. PK required.
Add attributes to an association, e.g. “Date” and “Decision” to the association “Applied”.
0..n
0..*
1..1
m..n
m..*