a. What forms and documents would KKD use in the process described? Which generic step(s) in the sales / collection process would use each form?

b. In a manner specified by your instructor, document the process described from KKD’s perspective. 

c. What risks do fundraising groups bear in the process? What internal controls would you recommend to a fundraising group to address those risks?

d. Consider the following tables KKD might maintain for the process: fundraising group table, sell fundraising certificates table, redeem fundraising certificates table, redeem fundraising certificates / inventory table. What fields would you include in each table? Indicate primary keys by underlining and foreign keys with brackets.

e. Based on the tables you laid out in (d), suggest one simple query and one complex query KKD might use. For each query, explain its purpose and indicate the fields you would incorporate.