50
Foreign Key Constraints
•OR
•
•
•
•
•
•(name, category) must be a PRIMARY KEY
CREATE TABLE Purchase (
prodName CHAR(30),
category VARCHAR(20),
    date DATETIME,
    FOREIGN KEY (prodName, category)
           REFERENCES  Product(name, category)