==========================================================
Sams Teach Yourself SQL in 10 Minutes - ISBN 0672321289
Appendix A - Sample Table Scripts
Create Products table

DBMS specific notes
  All tables should have primary keys defined. This table should
   use prod_id as its primary key.
  To enforce referential integrity, a foreign key should be defined
   on vend_id relating it to vend_id in VENDORS.
  If you are using Microsoft SQL Sever, Sybase, or Informix, you might
   want to use a datatype of MONEY, instead of DECIMAL(8,2), for the
   item_price column. If you are using Microsoft Access you might want
   to use a datatype of CURRENCY. DECIMAL(8,2) was used here because
   some DBMS' (most notably Oracle), do not support the MONEY datatype.
  Microsoft Access users should remove the (1000) from the prod_desc column.
  If you are using Informix, explicitly state NULL for the prod_desc column.
  DB2 users will need to specify where the table is to be created.

Important: When using this SQL statement only include
text beneath the lines below.
==========================================================

CREATE TABLE Products
(
	prod_id		CHAR(10)	NOT NULL,
	vend_id		CHAR(10)	NOT NULL,
	prod_name	CHAR(255)	NOT NULL,
	prod_price	DECIMAL(8,2)	NOT NULL,
	prod_desc	VARCHAR(1000)		
);
