Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The purchasing manager would like to know the names of vendors who have been paid on 8 / 3 / 2 3 . EXACTLY which

The purchasing manager would like to know the names of vendors who have been paid on 8/3/23. EXACTLY which tables below must be accessed to answer this query?
DEPARTMENTS (DEPT-NO, D-NAME, MANAGER)
REQUISITIONS (REQ-NO, RQ-DATE, DEPT-NO*, EID*)
ITEMS-REQUISITIONED (REQ-NO*, ITEM-NO*, QUANTITY-NEEDED)
INVENTORY (ITEM-NO, DESCRIPTION, COST-PRICE, SELLING-PRICE, QUANTITY-ON-HAND, REORDER-POINT)
VENDORS (VENDOR-NO, V-NAME, ADDRESS, VENDOR-PHONE-NO, BALANCE)
ITEMS-SUPPLIED (VENDOR-NO*, ITEM-NO*, CURRENT-PRICE)
PURCHASE-ORDERS (PO-NO, PO-DATE, VENDOR-NO*, EID*, AMOUNT, TARGET-DELIVERY-DATE)
ITEMS-ORDERED (PO-NO*, ITEM-NO*, QTY-ORDERED, ORDER-PRICE)
RECEIVING-REPORT (RR-NO,RR-DATE, PO-NO*, EID*)
ITEMS-RECEIVED (RR-NO*, ITEM-NO*, QTY-RECEIVED, CONDITION)
PURCHASES (PURCHASE-NO, PR-DATE, RR-NO*, VENDOR-INVOICE-NO, AMOUNT)
PAYMENTS (VOUCHER-NO, P-DATE, CHECK-NO, PURCHASE-NO*, AMOUNT)
EMPLOYEE (EID, EMP-NAME, EMP-ADDRESS, EMP-PHONE-NO)
a.
VENDORS, PURCHASE-ORDERS, ITEMS-ORDERED, PURCHASES, PAYMENTS
b.
PURCHASE-ORDERS, RECEIVING-REPORT, PURCHASES, PAYMENTS
c.
VENDORS, PURCHASE-ORDERS, RECEIVING-REPORT, PURCHASES, PAYMENTS
d.
VENDORS, PURCHASE-ORDERS, RECEIVING-REPORT, PURCHASES
e.
VENDORS, RECEIVING-REPORT, PURCHASES, PAYMENTS

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

Question

=+5 How does HRM relate to efforts to increase innovation?

Answered: 1 week ago

Question

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

Answered: 1 week ago