Accounting Information Systems 9th Edition by James Hall

Exercise 32

DETAILED SYSTEMS DESIGN
Refer to the diagram for Problem 13 for the expenditure cycle.
Required
a. List the entity database tables, and describe which entities need representing from an AIS perspective.
b. For each item identified as relevant to AIS, prepare a list of database tables along with primary and embedded foreign keys.
c. Prepare database tables showing attributes in normalized form.