Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

( begin{array}{ll}text { SUPPUER: } & text { DEPARTMENT: } text { : SUP_ID: SUPPDlier ID, INTEGER } & text { DEPT ID: Department

image text in transcribed

\( \begin{array}{ll}\text { SUPPUER: } & \text { DEPARTMENT: } \\ \text { : SUP_ID: SUPPDlier ID, INTEGER } & \text { DEPT ID: Department ID, } \\ \text { - SUP_NAME: SUpplier name, VARCHAR } \\ \text { - SUP_PHONE: Supplier phone number, } & \text { INTEGER }\end{array} \) - SUP_PHONE: Supplier phone number, - DEPT_NAME: Department name, - SUP_STATE: Supplier state, VARCHAR VARCHAR IIEM: - DEPT_PHONE: Department - ITEM_ID: Item ID, INTEGER - ITEM_DESC: Item description, - ITEM_PRICE:Item's Current - DEL_QUANTITY:Delivery Price, NUMBER \( \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 required inventory, NUMBER the order. It is stored to main SALE: historical data), NUMBER - SALE_ID: Sales ID, INTEGER - SALE_DATE: Date of sale, DATE Please consider the database and metadata above. Display a list of the item description, item quantity on hand, supplier id, which is either 1001 or 1005 , and item price, which is less than or equal to $100

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Programming Languages 12th International Symposium Dbpl 2009 Lyon France August 2009 Proceedings Lncs 5708

Authors: Philippa Gardner ,Floris Geerts

2009th Edition

3642037925, 978-3642037924

More Books

Students also viewed these Databases questions