7
com.umlet.element.Class
567
84
91
63
ZIP_CODE
--
ZIP: TEXT(5) (PK)
City: TEXT(25)
State: TEXT(2)
--
com.umlet.element.Class
399
84
126
77
CUSTOMER
--
CUST_NUM: NUM (PK)
CUST_NAME: TEXT(50)
CUST_ADDRESS: TEXT(30)
ZIP: TEXT(5) (FK)
--
com.umlet.element.Relation
343
98
69
34
lt=-
m1=M
m2=1
21;21;56;21
com.umlet.element.Relation
504
98
76
34
lt=-
m1=M
m2=1
21;21;63;21
com.umlet.element.Class
238
91
126
63
ORDER
--
ORDER_NUM: NUM (PK)
ORDER_DT: DATETIME
CUST_NUM: NUM (FK)
--
com.umlet.element.Class
7
91
147
63
ITEM
--
ITEM_NUM: NUM (PK)
ITEM_DESC: TEXT(75)
ITEM_C_PRICE: NUM
--
com.umlet.element.Relation
133
91
118
34
lt=-
m1=m
m2=m
21;21;105;21
com.umlet.element.Class
126
238
147
77
ORDER-ITEM
--
ORDER_NUM: NUM (PK)
ITEM_NUM: NUM (PK)
ITEM_QTY: NUM
ITEM_H_PRICE: NUM
--
com.umlet.element.Relation
175
91
34
160
21;147;21;21