-- Listing 1: Creating and Populating the Customers, Orders, OrderDetails and Products 
Tables
USE tempdb
SET NOCOUNT ON
CREATE TABLE Customers
(  custid  int  NOT NULL PRIMARY KEY,
  companyname varchar(25) NOT NULL)
INSERT INTO Customers VALUES(1001, 'Active customer 1001')
INSERT INTO Customers VALUES(1002, 'Inactive customer 1002')

CREATE TABLE Products
(  productid  int  NOT NULL PRIMARY KEY,
  productname varchar(25) NOT NULL)
INSERT INTO Products VALUES(301, 'Used product 301')
INSERT INTO Products VALUES(302, 'Used product 302')
INSERT INTO Products VALUES(303, 'Unused product 303')

CREATE TABLE Orders
(  orderid  int  NOT NULL PRIMARY KEY,
  custid  int  NULL  REFERENCES Customers)
INSERT INTO Orders VALUES(1, 1001)
INSERT INTO Orders VALUES(2, 1001)

CREATE TABLE OrderDetails
(  orderid  int  NOT NULL REFERENCES Orders,
  productid  int  NOT NULL REFERENCES Products,
  qty  int  NOT NULL,
  PRIMARY KEY(orderid, productid) )
INSERT INTO OrderDetails VALUES(1, 301, 5)
INSERT INTO OrderDetails VALUES(1, 302, 10)
INSERT INTO OrderDetails VALUES(2, 301, 15)
INSERT INTO OrderDetails VALUES(2, 302, 20)