Question: SUPPLIER: - SUP_ID:Supplier ID, INTEGER - SUP_NAME: Supplier name, VARCHAR DEPARTMENT: - SUP_PHONE; Supplier phone number, - DEPT_ID: Department ID, INTEGER VARCHAR - DEPT_NAME: Department

SUPPLIER: - SUP_ID:Supplier ID, INTEGER - SUP_NAME: Supplier name, VARCHAR DEPARTMENT: - SUP_PHONE; Supplier phone number, - DEPT_ID: Department ID, INTEGER VARCHAR - DEPT_NAME: Department name, - SUP_STATE: Supplier state, VARCHAR VARCHAR ITEM: - DEPT_PHONE: Department - ITEM_ID: Item ID, INTEGER - ITEM_DESC:Item description, phone number, VARCHAR - ITEM_PRICE: Item's Current DELNERY: - Price, NUMBER - DEL_ID: Delivery ID, NUMBER - ITEM_QOH: Item quantity on - DEL_QUANTITY: Dellvery hand, NUMBER - ITEM_MIN:Item minimum quantity (ordered quantity), NUMBER required inventory, NUMBER - DEL_PRICE: Delivery price (the price of the item at the time of SAIF: the order. It is stored to main - SALE ID: Sales ID, INTEGER - SALE_DATE Date of sale, DATE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
