LISTING 1: Creating and Populating the Products Table

CREATE TABLE Products
(
  productid   int         NOT NULL
         PRIMARY KEY
         CHECK (productid > 0),
  productname varchar(20) NOT NULL
)

INSERT INTO Products VALUES(147, 'Wand')
INSERT INTO Products VALUES(258, 'Racing Broom')
INSERT INTO Products VALUES(369, 'Invisibility Cloak')