Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

More Books

Students also viewed these Databases questions