Question 1

Why does an organisation need to prepare systems documentation?

Explain two reasons accountants need to be familiar with systems documentation techniques.

Question 2

The following data elements comprise the conceptual level schema for a database:

billing address cost

credit limit customer name customer number description invoice number item number price quantity on hand quantity sold shipping address terms

You are required to create the schema tables. Specify the primary key(s), foreign key(s), and other data for each table.

Question 3

Describe the information that can be obtained from each of these forms of systems documentation:

(a) Business process diagram

(b) Context diagram

(c) Physical data flow diagram

(d) Logical data flow diagram

(e) Systems flowchart