CREATE TABLE  Customers (
  CustomerID  INT UNSIGNED  NOT NULL  AUTO_INCREMENT  PRIMARY KEY,
  CustomerName  CHAR(30)  NOT NULL,
  Address  CHAR(50)  NOT NULL,
  Phone  CHAR(20)
);

CREATE TABLE  Orders (
  OrderID  INT UNSIGNED  NOT NULL  AUTO_INCREMENT  PRIMARY KEY,
  CustomerID  INT UNSIGNED  NOT NULL,
  Amount  FLOAT(6,2),
  Date  DATE  NOT NULL
);

CREATE TABLE  Books (
  ISBN  CHAR(13)  NOT NULL  PRIMARY KEY,
  Title  CHAR(60),
  Price  FLOAT(6,2)
);

CREATE TABLE  OrderDetails (
  OrderID  INT UNSIGNED  NOT NULL,
  ISBN  CHAR(13)  NOT NULL,
  Quantity  TINYINT UNSIGNED,

  PRIMARY KEY (OrderID, ISBN)
);

INSERT INTO Customers VALUES
  (NULL, "Julie Smith", "55 Grizzly Peak Rd., Butte", "(406) 555-5834"),
  (NULL, "Michelle Arthur", "Hauptstr. 29, Bern", NULL),
  (NULL, "Alan Wong", "Fauntleroy Circus, London", "(171) 555-1212");

INSERT INTO Orders VALUES
  (NULL, 1, 6.99, "2006-12-28"),
  (NULL, 3, 34.97, "2007-01-08"),
  (NULL, 2, 29.98, "2007-01-15"),
  (NULL, 3, 16.98, "2007-02-02");

INSERT INTO Books VALUES
  ("1-4127-0399-9", "Baby Animal Songs", 9.99),
  ("0-4391-1496-9", "I Spy Little Letters", 6.99),
  ("1-5906-9485-6", "Counting Rhymes", 14.99);

INSERT INTO OrderDetails VALUES
  (1, "0-4391-1496-9", 1),
  (2, "1-4127-0399-9", 2),
  (2, "1-5906-9485-6", 1),
  (3, "1-5906-9485-6", 2),
  (4, "1-4127-0399-9", 1),
  (4, "0-4391-1496-9", 1);