Listing 1: Script to Create and Populate the Orders and OrderDetails Tables
USE tempdb
CREATE TABLE Orders
(
  orderid VARCHAR(10) NOT NULL PRIMARY KEY,
  /* other columns */
)

CREATE TABLE OrderDetails
(
  orderid VARCHAR(10) NOT NULL REFERENCES Orders,
  productid INT NOT NULL,
  PRIMARY KEY(orderid, productid)
  /* other colums */
)

SET NOCOUNT ON
INSERT INTO Orders VALUES('A')
INSERT INTO Orders VALUES('B')
INSERT INTO Orders VALUES('C')
INSERT INTO Orders VALUES('D')
INSERT INTO Orders VALUES('E')

INSERT INTO OrderDetails VALUES('A', 1)
INSERT INTO OrderDetails VALUES('A', 2)
INSERT INTO OrderDetails VALUES('A', 3)
INSERT INTO OrderDetails VALUES('A', 4)
INSERT INTO OrderDetails VALUES('B', 2)
INSERT INTO OrderDetails VALUES('B', 3)
INSERT INTO OrderDetails VALUES('B', 4)
INSERT INTO OrderDetails VALUES('C', 3)
INSERT INTO OrderDetails VALUES('C', 4)
INSERT INTO OrderDetails VALUES('D', 4)