Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Referential integrity CANNOT be set between which of the following pairs of tables below? DEPARTMENTS (DEPT-NO, D-NAME, MANAGER) REQUISITIONS (REQ-NO, RQ-DATE, DEPT-NO*, EID*) ITEMS-REQUISITIONED (REQ-NO*,
Referential integrity CANNOT be set between which of the following pairs of tables below? 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. INVENTORY and ITEMS-REQUISITIONED b. RECEIVING-REPORTS and VENDORS c. INVENTORY and ITEMS-SUPPLIED d. PURCHASES and PAYMENTS e. RECEIVING-REPORT and PURCHASES
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