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.