LISTING 1: Creation Script for the Orders and OrderDetails Tables

CREATE TABLE Orders
(
  orderid    int      NOT NULL IDENTITY(1,1),
  customerid int      NOT NULL,
  orderdate  datetime NOT NULL,
  CONSTRAINT PK_Orders PRIMARY KEY(orderid)
)

CREATE TABLE OrderDetails
(
  orderid int NOT NULL,
  partid  int NOT NULL,
  qty     int NOT NULL,
  CONSTRAINT PK_OrderDetails PRIMARY KEY(orderid, partid),
  CONSTRAINT FK_OrderDetails_Orders
    FOREIGN KEY(orderid)
    REFERENCES Orders(orderid)
)
GO