Term
|
Definition
Each owner owns at least zero and at most many vehicles.
Each vehicle is owned by at least one and at most many owners.
Each person has at least zero and at most one license.
Each license belongs to exactly one person. |
|
|
Term
|
Definition
| The full relationship name Entity-RelatesTo-Entity is read clockwise |
|
|
Term
| Attributes are presumed ___, ___, and _ __. |
|
Definition
| singular, optional, and not unique. |
|
|
Term
|
Definition
OfficerID is singular, required, and unique.
AwardCode is plural, optional, and not unique.
BadgeNumber and DepartmentCode are singular, required, and not unique. The composite (BadgeNumber, DepartmentCode) is unique. |
|
|
Term
|
Definition
| NOT NULL and UNIQUE columns. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
checks if at least one of the conditions is true.
If either condition is true (or both are true), the result will be true. |
|
|
