Accounting Info System Requirements

Planning

Do initial planning to determine the need for and feasibility of developing a new database system. Is the proposed system technologically and economically feasible?

Requirements Analysis

Involves: identifying user information needs defining the scope of the proposed database system determining preliminary hardware and software requirements.

Design

Develop the structure of the database.

2 Major Steps: Logical design – Flowcharts, Data Flow Diagrams, Entity-Relationship Diagrams, Physical design – Converting logical model into relational table “schemas”. Using software to translate the physical schema into actual database structure. In a relational database build tables, then queries, forms and reports.

Implementation

Get the new database system working, testing the new system, transferring data from existing files to the new database, training employees on how to use the new system.

Role of the Accountant

How can accountants be involved in all stages of the SDLC?

In the planning stage, accountants both provide some of the information used to evaluate the feasibility of the proposed project and participate in making that decision. In the requirements analysis and design stages, accountants participate in identifying user information needs, developing the logical and physical models and specifying controls. Accountants with good IT skills may participate in the coding stage. During the implementation stage, accountants are involved in testing the accuracy of the new database and the application programs that will use that data. Finally, accountants use the database system to process transactions.

Effects of Databases on Accounting: External reporting may become less structured, done over the Internet through web pages or sent in the form of a CD database. Less emphasis on Double-entry bookkeeping, Decision-making support is enhanced.