User's Manual

Table Description

SalesRep All sales representatives that work 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 All customers that do 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,

PRIMARY KEY (cust_key)

)

150