Sybase DC38133-01-0902-01 manual Following information, 106

Table	Description
Customer	All customers that do business with the company. The
	Customer table includes the following columns:
	♦ cust_key	An identifier for each customer. This is the
	primary key.
	♦ name The name of each customer.
	♦ rep_key	An identifier for the sales representative in a
	sales relationship. This is a foreign key to the SalesRep
	table.

The SQL statement creating this table is as follows:

CREATE TABLE Customer (

Cust_key CHAR(12) NOT NULL,

Name CHAR(40) NOT NULL,

Rep_key CHAR(12) NOT NULL,

FOREIGN KEY REFERENCES SalesRep,

PRIMARY KEY (cust_key)

	)
Contact	All individual contacts that do business with the company.
	Each contact belongs to a single customer. The Contact
	table includes the following columns:
	♦ contact_key			An identifier for each contact. This is
	the primary key.
	♦ name	The name of each contact.
	♦ cust_key		An identifier for the customer to which the
	contact belongs. This is a foreign key to the Customer
	table.
	The SQL statement creating this table is:
	CREATE TABLE Contact (
	Contact_key			CHAR(12) NOT NULL,
	Name	CHAR(40) NOT NULL,
	Cust_key		CHAR(12) NOT NULL,
	FOREIGN KEY			REFERENCES
	Customer,
	PRIMARY KEY			(contact_key)
	)

Replication goals	The goals of the design are to provide each sales representative with the
	following information:
	♦ The complete SalesRep table.
	♦ Those customers assigned to them, from the Customer table.

106