Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SUPPUER: IIEM: - TTEM_DESC: Item description. - VARCHAR - IEM_PRICE: Item's Current DEL_QuANTITY:Delivery - ITEM_MIN: Item minimum required inventory, NUMBER - SAIE: SALE ID: Sales
SUPPUER: IIEM: - TTEM_DESC: Item description. - VARCHAR - IEM_PRICE: Item's Current DEL_QuANTITY:Delivery - ITEM_MIN: Item minimum required inventory, NUMBER - SAIE: SALE ID: Sales ID, INTEGER historical data), NUMBER - Sale_Date: Date of sale, Date Please consider the database and metadata above. List the departments (dept id, dept name) that have ordered items provided by suppliers from FL (state). SUPPUER: - SUP_ID: SUpplierID, INTEGER DEPARTMENTI - SUP_NAME; Supplier name, VARCHAR - DEPT_ID: Department ID, - SUP_PHONE: Supplier phone number, - DEPT_NAME: Department name, VARCHAR - SUP_STATE: SUPDlier state, VARCHAR VAROHAR IIEM: - DEPT_PHONE: Department - ITEM_ID: Item ID, INTEGER phone number, VARCHAR - ITEM DESC: Item description, VARCHAR \( \begin{array}{ll}\text { - ITEM_PRICE: Item's Current } & \text { DEL_ID: DeliveryID, NUMBER } \\ \text { - Price, NUMBER } & \text { DE_QUANTITY:Delivery } \\ \text { - ITEM_QOH: Item quantity on } & \text { quantity (ordered quantity), } \\ & \text { NUMBER }\end{array} \) DELNERY: \( \begin{array}{ll}\text { - ITEM_QOH:item quantity on } & \text { NUMBER } \\ \text { - hand, NUMBER } & \text { - DEL_PRICE: Delivery price (the }\end{array} \) - ITEM_MIN: Item minimum price of the item at the time of SALE:-SALEIDID:SalesID,INTEGERtheorder.Itisstoredtomain - SALE_ID: Sales ID, INTEGER - SALE_DATE: Date of sale, DATE Please consider the database and metadata above. Increase item price for the item having id 2001 to 600
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