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

DBMS specific notes
  All tables should have primary keys defined. This table should
   use order_num as its primary key.
  To enforce referential integrity, a foreign key should be
   defined on cust_id relating it to cust_id in CUSTOMERS.
  If you are using Oracle, change the order_date datatype
   from DATETIME to DATE.
  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 Orders
(
	order_num	INTEGER		NOT NULL,
	order_date	DATETIME	NOT NULL,
	cust_id		CHAR(10)	NOT NULL
);
