Table A-1: Structure of the slspers Table

ColumnName Datatype Description

repid varchar(3) The representative ID is
analphanumeric ID that
uniquely identifies each
sales executive.
fname varchar(10) The first name of a sales
executive.
lname varchar(20) The last name of a sales
executive. commrate float
The commission rate earned
by each executive.

Table A-2: Structure of the Sales Table

ColumnName Datatype Description
ordnum varchar(5) The order number which
uniquely identifies each
sale. sldate datetime The
date of [Link] int The
quantity of units sold for an
order.
custnum varchar(5) The customer number.
partnum varchar(5) The part number which
uniquelyidentifies the book
sold.
Repid varchar(3) The representative ID which
uniquely identifies the sales
executive who contributed
to the
sale.

Table A-3: Structure of the Titles Table

ColumnName Datatype Description
partnum varchar(5) The part number of a book
that uniquely identifies the
book.
bktitle varchar(40) The title of a book.
devcost decimal(19,2) The cost of developing the
book.
slprice decimal(19,2) The sale price of a book.
pubdate datetime The publishing date of a
book.

Table A-4: Structure of the Customers Table

ColumnName Datatype Description
custnum varchar(5) The customer number that
uniquely identifies a
customer.
referredby varchar(5) The customer number that
represents a customer who
referred the bookstore.
custname varchar(30) The name of the customer.
 address varchar(25) The address of the
customer.
city varchar(20) The city where the customer
resides.
state varchar(2) The state where the
customer’s city is located.
zipcode varchar(12) The zip code of the
customer’sstate.
repid varchar(3) The representative ID that
identifiesthe sales executive
who had sold books to the
customer.

Table A-5: Structure of the Obsolete_titles Table

ColumnName Datatype Description
partnum varchar(10) NOT NULL The part number of a book
that uniquely identifies the
book.
bktitle varchar(40) NOT NULL The title of a [Link]
decimal(19,2) The cost of
developing the book.
slprice decimal(19,2) The sale price of a book.
pubdate datetime The publishing date of a
book.

Table A-6: Structure of the potential_customers Table

ColumnName Datatype Description
custnum varchar(5) The customer
number that
uniquely identifies a
customer.
referredby varchar(5) The customer
number that
represents a
customer who
recommended the
bookstore.
custname varchar(30) The name of the
customer.
address varchar(50) The address of the
customer.
mobileno varchar(10) NOT The customer’s
NULL mobile number.
repid varchar(3) The representative
ID that identifies the
sales executive who
had sold books to
the customer
.

Table A-7: Structure of the Titles2 Table

ColumnName Datatype Description
partnum varchar(5) The part number of a book
that uniquely identifies the
book.
bktitle varchar(40) The title of a book.
devcost decimal(19,2) The cost of developing the
book.
slprice decimal(19,2) The sales price of a book.
pubdate datetime The publishing date of a
book.