updated project plan

CUST

*P CUST_ID NUMBER (7) * FNAME VARCHAR2 (100) * LNAME VARCHAR2 (7)

CUST_PK (CUST_ID)

ORDER

*P ORDER_ID NUMBER (7) * ORD_DESC VARCHAR2 (300) *PF TRANSCTN_TRAN_ID NUMBER (7) *PF PROMO_PRM_ID NUMBER (7)

ORDER_PK (ORDER_ID, TRANSCTN_TRAN_ID, PROMO_PRM_ID)

ORDER_PROMO_FK (PROMO_PRM_ID) ORDER_TRANSCTN_FK (TRANSCTN_TRAN_ID)

PROMO

*P PRM_ID NUMBER (7) PRM_DESC VARCHAR2 (200)

* PRM_AMT NUMBER (10,2)

PROMO_PK (PRM_ID)

SUPLR

*P SUP_ID NUMBER (7) * SUP_NAME VARCHAR2 (300)

ADDRID NUMBER (7)

SUPLR_PK (SUP_ID)

TRANSCTN

*P TRAN_ID NUMBER (7) CARD_NUM NUMBER (14)

TRANSCTN_PK (TRAN_ID)

WHRHSE

*P WHR_ID NUMBER (7) * WHR_NM VARCHAR2 (100) *PF INVT_INVT_ID NUMBER (7) *PF INVT_SUP_ID NUMBER (7)

WHRHSE_PK (WHR_ID, INVT_INVT_ID, INVT_SUP_ID)

WHRHSE_INVT_FK (INVT_INVT_ID, INVT_SUP_ID)

INVT

*P INVT_ID NUMBER (7) * INVT_DESC VARCHAR2 (300) * SIZE NUMBER (2) * INV_DATE DATE * IN_STOCK NUMBER (7) * COST NUMBER (10,2) *PF SUPLR_SUP_ID NUMBER (7)

INVT_PK (INVT_ID, SUPLR_SUP_ID)

INVT_SUPLR_FK (SUPLR_SUP_ID)

SHIPNG

*P SHPNG_ID NUMBER (7) SHNG_DESC VARCHAR2 (100)

* SHPNG_STATUS CHAR (1) *PF ORDER_ORDER_ID NUMBER (7) *PF ORDER_TRANSCTN_TRAN_ID NUMBER (7) *PF ORDER_PROMO_PRM_ID NUMBER (7)

SHIPNG_PK (SHPNG_ID, ORDER_ORDER_ID, ORDER_TRANSCTN_TRAN_ID, ORDER_PROMO_PRM_ID)

SHIPNG_ORDER_FK (ORDER_ORDER_ID, ORDER_TRANSCTN_TRAN_ID, ORDER_PROMO_PRM_ID)

SHP_CRT

*P SHP_ID NUMBER (7) * COST NUMBER (10,2) *PF CUST_CUST_ID NUMBER (7) *PF INVT_INVT_ID NUMBER (7) *PF INVT_SUP_ID NUMBER (7) *PF TRANSCTN_TRAN_ID NUMBER (7)

SHP_CRT_PK (SHP_ID, CUST_CUST_ID, INVT_INVT_ID, INVT_SUP_ID, TRANSCTN_TRAN_ID)

SHP_CRT_TRANSCTN_FK (TRANSCTN_TRAN_ID) SHP_CRT_INVT_FK (INVT_INVT_ID, INVT_SUP_ID) SHP_CRT_CUST_FK (CUST_CUST_ID)

EMPLY

*P EMPID NUMBER (7) * FNAME VARCHAR2 (100) * LNAME VARCHAR2 (100) * DEPT VARCHAR2 (100) * DESGN VARCHAR2 (100) *PF ADDRSS_ADDRID NUMBER (7) *PF ADDRSS_SHPNG_ID NUMBER (7) *PF ADDRSS_ORDER_ID NUMBER (7) *PF ADDRSS_TRAN_ID NUMBER (7) *PF ADDRSS_PRM_ID NUMBER (7) *PF WHRHSE_WHR_ID NUMBER (7) *PF WHRHSE_INVT_ID NUMBER (7) *PF WHRHSE_SUP_ID NUMBER (7)

EMPLY_PK (EMPID, ADDRSS_ADDRID, ADDRSS_SHPNG_ID, ADDRSS_ORDER_ID, ADDRSS_TRAN_ID, ADDRSS_PRM_ID, WHRHSE_WHR_ID, WHRHSE_INVT_ID, WHRHSE_SUP_ID)

EMPLY_ADDRSS_FK (ADDRSS_ADDRID, ADDRSS_SHPNG_ID, ADDRSS_ORDER_ID, ADDRSS_TRAN_ID, ADDRSS_PRM_ID) EMPLY_WHRHSE_FK (WHRHSE_WHR_ID, WHRHSE_INVT_ID, WHRHSE_SUP_ID)

ADDRSS

*P ADDRID NUMBER (7) RES_NO VARCHAR2 (20)

* STREET VARCHAR2 (300) * CITY VARCHAR2 (100)

STATE CHAR (2) ZIP CHAR (10)

* ADDRTYPE CHAR *PF SHIPNG_SHPNG_ID NUMBER (7) *PF SHIPNG_ORDER_ORDER_ID NUMBER (7) *PF SHIPNG_ORDER_TRANSCTN_TRAN_ID NUMBER (7) *PF SHIPNG_ORDER_PROMO_PRM_ID NUMBER (7)

ADDRSS_PK (ADDRID, SHIPNG_SHPNG_ID, SHIPNG_ORDER_ORDER_ID, SHIPNG_ORDER_TRANSCTN_TRAN_ID, SHIPNG_ORDER_PROMO_PRM_ID)

ADDRSS_SHIPNG_FK (SHIPNG_SHPNG_ID, SHIPNG_ORDER_ORDER_ID, SHIPNG_ORDER_TRANSCTN_TRAN_ID, SHIPNG_ORDER_PROMO_PRM_ID)