Key Constraints

• Consider Works_In: An employee can work in many departments; a dept can have many employees.

• In contrast, each dept has at most one manager, according to the key constraint on Manages.

Many-to-Many

1-to-1

1-to Many

Many-to-1

budget

did

Departments

Previous slide

Next slide

Back to first slide

View graphic version