54
CREATE TABLE Purchase (
prodName CHAR(30)
CHECK (prodName IN
                                  SELECT Product.name
                                  FROM Product),
    date DATETIME NOT NULL)
What
is the difference from
Foreign-Key ?