Question
1.The purchasing manager would like to know the name of the employee who received inventory items on 6/6/20 and wants to know the descriptions of
1.The purchasing manager would like to know the name of the employee who received inventory items on 6/6/20 and wants to know the descriptions of the items received and the vendor ID of the vendor from whom the items were received. Name the tables that must be included in this query.
2.The payments accountant wants to know the amount paid to vendor 105 for inventory items received on PO 1834. Name the tables that must be included in this query
3.The purchasing manager wants to know the names of the vendors the company sent purchase orders to in February 2020 and which item numbers and quantities were ordered. Name the tables that must be included in this query
4.Name 2 tables in this database, between which it is impossible to enforce referential integrity.
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)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