Foreign Key

?? (r2) ? ?K1 (r1)

Formally expressing the integrity constraint.

For referential constraint to make sense ? must be equal to K1.

Intuitively, consider a query “insert account xyz with abc as branch” . What if “abc” does not exist?

Previous slide

Next slide

Back to first slide

View graphic version