Alternative (min, max) notation for relationship structural constraints:

Specified on each participation of an entity type E in a relationship type R
Specifies that each entity e in E participates in at least min and at most max
relationship instances in R
Default(no constraint): min=0, max=n (signifying no limit)
Must have min_max, min_0, max _1
Derived from the knowledge of mini-world constraints
Examples:
A department has exactly one manager and an employee can manage at most one
department.
Specify (0,1) for participation of EMPLOYEE in MANAGES
Specify (1,1) for participation of DEPARTMENT in MANAGES
An employee can work for exactly one department but a department can have any
number of employees.
Specify (1,1) for participation of EMPLOYEE in WORKS_FOR

Specify (0,n) for participation of DEPARTMENT in WORKS_FOR

0 comments