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

DBMS specific notes
  All tables should have primary keys defined. This table should use
   order_num and order_item as its primary keys.
  To enforce referential integrity, foreign keys should be defined
   on order_num relating it to order_num in Orders and prod_id relating
   it to prod_id in Products.
  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.
  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 OrderItems
(
	order_num	INTEGER		NOT NULL,
	order_item	INTEGER		NOT NULL,
	prod_id		CHAR(10)	NOT NULL,
	quantity	INTEGER		NOT NULL,
	item_price	DECIMAL(8,2)	NOT NULL
);
