User's Manual

Table Description

SalesRep One row for each sales representative that works for the

company. The SalesRep table has the following columns:

♦ rep_key An identiﬁer 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)

)

Customer One row for each customer that does business with the

company. The Customer table includes the following

columns:

♦ cust_key An identiﬁer for each customer. This is the

primary key.

♦ name The name of each customer.

♦ rep_key An identiﬁer 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 (rep_key

PRIMARY KEY (cust_key)

)

Replication goals

The goals of the replication design are to provide each sales representative

with the following information:

♦ The complete SalesRep table.

♦ Those customers assigned to them.

The tutorials describe how to meet this goal using SQL Remote.