User's Manual

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