Sybase DC38133-01-0902-01 manual 150, Repkey

Table	Description
SalesRep	All sales representatives that work for the company. The
	SalesRep table has the following columns:
	♦ rep_key		An identifier for each sales representative.
	This is the primary key.
	♦ name	The name of each sales representative.
	The SQL statement creating this table is as follows:
	CREATE TABLE SalesRep (
	rep_key CHAR(12) NOT NULL,
	name CHAR(40) NOT NULL,
	PRIMARY KEY (rep_key)
	)
	go
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 ( rep_key ) REFERENCES SalesRep, PRIMARY KEY (cust_key)

)

go

150