Customers PK Cust_ID Cust FName Cust_LName Cust_Address Cust_PNumber PK Pay Id Pay Method Place PK Ord Id Ord_Date Order Ord TotalPrice FK Cust Id FK Ord_Item_id FK Pay Id FK Ship Id belong Payment receive consists PK Ship Id Ship Date FK Cust_ID PK Cat Id Category Cat Name belong Shipment has PK Prod ID Prod Name Prod_Price FK Cat Id Product consists Order item PK Ord_Item_id Ord_Item_UnitPrice Ord Quantity FK Prod ID