Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

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

International Financial Reporting

Authors: Alan Melville

7th Edition

1292293128, 9781292293127

More Books

Students also viewed these Accounting questions