Listing A: Creating and Populating the Customers and Orders Tables
SET NOCOUNT ON;
USE tempdb;
GO
IF OBJECT_ID('dbo.Orders', 'U') IS NOT NULL
  DROP TABLE dbo.Orders;
IF OBJECT_ID('dbo.Customers', 'U') IS NOT NULL
  DROP TABLE dbo.Customers;
GO
CREATE TABLE dbo.Customers
(
  custid VARCHAR(5) NOT NULL PRIMARY KEY,
  custname VARCHAR(20) NOT NULL
);
INSERT INTO dbo.Customers VALUES('A', 'Cust A');
INSERT INTO dbo.Customers VALUES('B', 'Cust B');
INSERT INTO dbo.Customers VALUES('C', 'Cust C');

CREATE TABLE dbo.Orders
(
  orderid INT NOT NULL PRIMARY KEY,
  customerid VARCHAR(5) NOT NULL REFERENCES dbo.Customers
);
INSERT INTO dbo.Orders VALUES(1, 'A');
INSERT INTO dbo.Orders VALUES(2, 'A');
INSERT INTO dbo.Orders VALUES(3, 'A');
INSERT INTO dbo.Orders VALUES(4, 'B');
INSERT INTO dbo.Orders VALUES(5, 'B');
INSERT INTO dbo.Orders VALUES(6, 'B');
GO