You are now ready to address the specifics of the new AIS at BeGood. As part of your research, document the following, which would become part of your final presentation to management, if you were carrying the project through to the end. Your documentation can be in the form of tables, SmartArt, PowerPoint, Word, or Excel. Use what best works for the documentation you are creating:
- Identify the tables that you would need to create a working database for the company’s receivables, payables, and inventory.
- Create relationships for your various tables and databases. For instance, how does the A/P database interface with the Inventory Database?
- Document your work providing a databases diagram (schema).
- Documenting an organization’s AIS would become part of a larger scale user manual for the accounting and information technology teams to use for reference and to assist the audit team with understanding how the organization’s systems work together. Write the appropriate policies and procedures that arise from the tasks above that would be included in this type of user manual. Your information should also address the security of the systems involved.