CREATE TABLE SALESREPS (
EMPL_NUM int NOT NULL, 
NAME varchar(50) NOT NULL, 
AGE int,
REP_OFFICE int,
TITLE varchar(30),
HIRE_DATE datetime,
MANAGER int,
QUOTA money,
SALES money);

CREATE TABLE PRODUCTS(
MFR_ID char(3) NOT NULL,
PRODUCT_ID varchar(5) NOT NULL,
DESCRIPTION varchar(60) NOT NULL,
PRICE money NOT NULL,
QTY_ON_HAND int);

CREATE TABLE ORDERS(
ORDER_NUM integer NOT NULL,
ORDER_DATE datetime NOT NULL,
CUST int NOT NULL,
REP int NOT NULL,
MFR char(3) NOT NULL,
PRODUCT varchar(5) NOT NULL,
QTY int NOT NULL,
AMOUNT money NOT NULL);

CREATE TABLE OFFICES(
OFFICE int NOT NULL,
CITY varchar(40) NOT NULL,
REGION varchar(20) NOT NULL,
MGR int NOT NULL,
TARGET money NOT NULL,
SALES money NOT NULL);

CREATE TABLE CUSTOMERS(
CUST_NUM int NOT NULL,
COMPANY varchar(80) NOT NULL,
CUST_REP int NOT NULL,
CREDIT_LIMIT money NOT NULL);