Listing 3: Creation Script for Sample Tables
CREATE TABLE Products
(product_id int NOT NULL, product_price money NULL)

CREATE TABLE Orders
(order_id int IDENTITY, product_id int NOT NULL,
quantity int NOT NULL CHECK (quantity >= 0),
unit_price money NOT NULL,
ext_price money NOT NULL)

/* Products data */
INSERT Products (product_id, product_price) VALUES (1, $19.95)
INSERT Products (product_id, product_price) VALUES (2, $29.95)
INSERT Products (product_id, product_price) VALUES (3, $39.95)
INSERT Products (product_id, product_price) VALUES (4, $11.00)
INSERT Products (product_id) VALUES (5)