updated project plan

ADDRSS

*P ADDRID NUMERIC (7) RES_NO VARCHAR (20)

* STREET VARCHAR (300) * CITY VARCHAR (100)

STATE CHAR (2) ZIP CHAR (10)

* ADDRTYPE CHAR *PF SHPNG_ID NUMERIC (7) *PF ORDER_ID NUMERIC (7) *PF TRAN_ID NUMERIC (7) *PF PRM_ID NUMERIC (7)

ADDRSS PK (ADDRID, SHPNG_ID, ORDER_ID, TRAN_ID, PRM_ID)

TRANSCTN

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

TRANSCTN PK (TRAN_ID)

SHIPNG

*P SHPNG_ID NUMERIC (7) SHNG_DESC VARCHAR (100)

* SHPNG_STATUS CHAR (1) *PF ORDER_ID NUMERIC (7) *PF TRAN_ID NUMERIC (7) *PF PRM_ID NUMERIC (7)

SHIPNG PK (SHPNG_ID, ORDER_ID, TRAN_ID, PRM_ID)

ORDER

*P ORDER_ID NUMERIC (7) * ORD_DESC VARCHAR (300) *PF TRAN_ID NUMERIC (7) *PF PRM_ID NUMERIC (7)

ORDER PK (ORDER_ID, TRAN_ID, PRM_ID)

PROMO

*P PRM_ID NUMERIC (7) PRM_DESC VARCHAR (200)

* PRM_AMT DECIMAL (10,2)

PROMO PK (PRM_ID)

INVT

*P INVT_ID NUMERIC (7) * INVT_DESC VARCHAR (300) * SIZE NUMERIC (2) * INV_DATE Date * IN_STOCK NUMERIC (7) * COST DECIMAL (10,2) *PF SUP_ID NUMERIC (7)

INVT PK (INVT_ID, SUP_ID)

CUST

*P CUST_ID NUMERIC (7) * FNAME VARCHAR (100) * LNAME VARCHAR (7)

CUST PK (CUST_ID )

SUPLR

*P SUP_ID NUMERIC (7) * SUP_NAME VARCHAR (300)

ADDRID NUMERIC (7)

SUPLR PK (SUP_ID)

WHRHSE

*P WHR_ID NUMERIC (7) * WHR_NM VARCHAR (100) *PF INVT_ID NUMERIC (7) *PF SUP_ID NUMERIC (7)

WHRHSE PK (WHR_ID, INVT_ID, SUP_ID)

EMPLY

*P EMPID NUMERIC (7) * FNAME VARCHAR (100) * LNAME VARCHAR (100) * DEPT VARCHAR (100) * DESGN VARCHAR (100) *PF ADDRID NUMERIC (7) *PF SHPNG_ID NUMERIC (7) *PF ORDER_ID NUMERIC (7) *PF TRAN_ID NUMERIC (7) *PF PRM_ID NUMERIC (7) *PF WHR_ID NUMERIC (7) *PF INVT_ID NUMERIC (7) *PF SUP_ID NUMERIC (7)

EMPLY PK (EMPID, ADDRID, SHPNG_ID, ORDER_ID, TRAN_ID, PRM_ID, WHR_ID, INVT_ID, SUP_ID)

SHP_CRT

*P SHP_ID NUMERIC (7) * COST DECIMAL (10,2) *PF CUST_ID NUMERIC (7) *PF INVT_ID NUMERIC (7) *PF SUP_ID NUMERIC (7) *PF TRAN_ID NUMERIC (7)

SHP_CRT PK (SHP_ID, CUST_ID , INVT_ID, SUP_ID, TRAN_ID)