•You guess
they are
•I tell you
so
•Foreign keys are a
method for schema designers to tell you so (7.1)
–A foreign key
states that a column is a reference to the key of another table
ex: Product.manufacturer is foreign key of Company
–Gives
information and enforces constraint
–