48
Foreign Key Constraints
•CREATE TABLE Purchase (
• prodName CHAR(30)
• REFERENCES Product(name),
•    date DATETIME)
prodName is a foreign key to Product(name)
name must be a key in Product
Referential
integrity
constraints