Question: Use the DATE ( . . . ) function to add months to the previous audit date. Define a function NextAudit 2 _ CSA which

Use the DATE(...) function to add months to the previous audit date. Define a function NextAudit2_CSA which
takes the business rule as a function argument.
NextAudit2_CSA has the arguments as shown in this LAMBDA:
LAMBDA(last_audit,company_size,audit_result,business_rule,LET(...)),
where business_rule is defined by the above LAMBDA. Make use of the LAMBDA helper function MAP
to implement NextAudit2_CSA.
The rules are:
1. If a firm is large and failed, their next audit is in two months.
2. If a firm is large and passed, their next audit is in three months.
3. If a firm is small, their next audit is in four months

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!