Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 2 (3.33 points) Suppose a table EFTrequest with primary key EFTrequested contains EFT requests. Suppose a table EFTconfirm with primary key EFTconfirmed and an
Question 2 (3.33 points) Suppose a table EFTrequest with primary key EFTrequested contains EFT requests. Suppose a table EFTconfirm with primary key EFTconfirmed and an attribute EFTrequested contains EFT confirmations. Payables staff could verify that the EFT payments the bank made were complete by running a query with a: Left outer join on EFTconfirm to EFTrequest Left outer join on EFTrequest to EFTconfirm Inner join on EFTconfirm and EFTrequest Cartesian product on EFTrequest and EFTconfirm Verifying with a query that every EFT confirmation has a corresponding EFT request gives assurance of: Accuracy of payments O Completeness and validity of payments Completeness of payments Validity of payments
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