Foreign Key Constraints

Purchase:

buyer price product

Joe $20 gizmo

Jack $20 E-gizmo

Product:

name manufacturer description

gizmo G-sym great stuff

E-gizmo G-sym even better

An attribute of a relation R is must refer to a key of a relation S.

(need to be careful during deletions).

Previous slide

Next slide

Back to first slide

View graphic version