CREATE TABLE CUSTOMERS
( 
      CUST_NUM   INTEGER  NOT NULL  UNIQUE , 
      COMPANY   VARCHAR(20)   NOT NULL ,
      CUST_REP  INTEGER ,
      CREDIT_LIMIT REAL ,
      PRIMARY KEY ( CUST_NUM ) 
)
---
CREATE TABLE OFFICES
( 
     OFFICE INTEGER   NOT NULL UNIQUE ,
     CITY  VARCHAR(15)   NOT NULL  ,
     REGION   VARCHAR(10)   NOT NULL , 
     MGR INTEGER   ,
     TARGET  REAL ,
     SALES REAL  NOT NULL ,
     PRIMARY KEY  ( OFFICE ) 
)
---
CREATE TABLE SALESREPS
(
      EMPL_NUM INTEGER NOT NULL  UNIQUE ,
      NAME  VARCHAR(15)  NOT NULL ,
      AGE  INTEGER  ,
      REP_OFFICE INTEGER  ,
      TITLE      VARCHAR(10)  ,
      HIRE_DATE DATE  NOT NULL , 
      MANAGER  INTEGER , 
      QUOTA REAL  ,
      SALES  REAL  NOT NULL ,
      PRIMARY KEY ( EMPL_NUM )
 )
---
CREATE TABLE ORDERS
(
      ORDER_NUM   INTEGER  NOT NULL UNIQUE ,
      ORDER_DATE  DATE       NOT NULL  ,
      CUST INTEGER                NOT NULL ,
      REP INTEGER , 
      MFR  CHAR(3) NOT NULL ,
      PRODUCT CHAR(6) NOT NULL ,
      QTY INTEGER NOT NULL ,
      AMOUNT REAL  NOT NULL ,
      PRIMARY KEY ( ORDER_NUM )
 )
---
CREATE TABLE PRODUCTS
(
      MFR_ID   CHAR(3) NOT NULL ,
      PRODUCT_ID  CHAR(5)  NOT NULL ,
      DESCRIPTION VARCHAR(20)  NOT NULL ,
      PRICE REAL  NOT NULL ,
      QTY_ON_HAND INTEGER  NOT NULL ,
      PRIMARY KEY ( MFR_ID , PRODUCT_ID ),
      UNIQUE ( MFR_ID ,PRODUCT_ID )
)