Question: SUPPUER: - SUP_ID: Supplier ID, INTEGER - SUP_ NAME: Supplier name, VARCHAR DEPARTMENT: - SUP_PHONE: Supplier phone number, - DEPT_ID. Department ID, INTEGER VARCHAR -

 SUPPUER: - SUP_ID: Supplier ID, INTEGER - SUP_ NAME: Supplier name,

SUPPUER: - 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 IIEM: - DEPT_PHONE: Department - ITEM_ID: item ID, INtEgER - IEM-DESC: Item description, DELNERY: - ItEM_PRICE: Item's Current - DR_id. Delivery ID, NUMBER - ITEM_PRICE: Item's Current - DR_QUANTIIYY: Delivery - ITEM_QOH: Item quantity on Quantity (ordered quantity), hand, NUMBER - ITEM_MIN: item minimum - DE_PRICE: Delvery price (the required inventory, NUMBER the order. It is stored to main SALE: historical data), NUMBER - SALE_DATE: Date of sale, DATE Please consider the database and metadata above. The company provides a 30-day warranty for items when an item is sold. When 30 days pass over the item sale date, the warranty expires - display the item id, sale date, and a calculated column to find the item expiration 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!