Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started