Ais - Accounting Information System

[pic 1]

Academic Year 2013/2014 (Term 1)

ACCT 221 – Accounting Information Systems (G1)

Professor Gary Pan

[pic 2]

Done by:

Ko Hock Seng

Ng Shaoyong Alvan

Samuel Lee Choon Kiat

Low Jun Wei John

Chen Li Wen

Table of Contents

Company Background and Information:        

Requirement 1: System Documentation        

1.1 Revenue Cycle        

1.1.1        Revenue Cycle Narrative        

1.1.2        Table of Entities and Activities        

1.1.3        Context Diagram        

1.1.4        Physical Data Flow Diagram        

1.1.5        Annotated Table of Entities and Activities        

1.1.6        Level – 0 Logical Data Flow Diagram        

1.1.7        Level – 1 Logical Data Flow Diagram        

1.2        Expenditure Cycle        

1.2.1        Expenditure Cycle Narrative        

1.2.2        System Flowchart        

Requirement 2: Resource Entity Activity Database Modelling        

2.1        Adapted Narrative        

2.1.1        Adapted Narrative of Revenue Cycle        

2.1.2        Adapted Narrative of Expenditure Cycle        

2.2        REA Diagram        

2.3        Cardinalities Explanation        

2.3.1        Revenue Cycle Explanation        

2.3.2        Expenditure Cycle Explanation        

2.4        Tables        

Requirement 3: Control Matrix        

3.1        Control Matrix        

4.1        Explanation of Control Plans        

P-1: Populate Input Screen with Master Data        

P-2: Customer Credit Check        

P-3: Independent Pricing        

P-4: One-for-one Checking of Goods, Picking Ticket        

M-1: Independent Customer Master Data Maintenance