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:

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!