47
Other Keys
•CREATE TABLE Product (
• productID  CHAR(10),
• name CHAR(30),
• category VARCHAR(20),
• price INT,
    PRIMARY KEY (productID),
•    UNIQUE (name, category))
There is at most one PRIMARY KEY;
there can be many UNIQUE