Structuring Database for Accounting

characteristics): one it is integrated and second it is shared . Integrated property implies that distinct data tables have been logically organised. The purpose is to reduce or eliminate redundancy (or duplicity) and also to facilitate better data access. The shared property means that all those who are authorised to use data/information have access to relevant data.

Thus, a database is a collection of related data that represents some aspect of the real world (called mini-world or Reality). Accordingly, accounting database is a collection of related accounting data to represent some aspect of an accounting information system. Database is designed, built and populated (or loaded) with data for a specific purpose. (d) Information : refers to data that have been processed and organised in a form, which is suitable for decision-making.

The raw data when processed in accordance with decision usefulness of a decision-maker becomes information. In other words, information is a data that have been processed and refined and then presented in a format that is convenient for decision- making or other organisational activities. Fig. .

: The diagram showing the transaction data processing and information levels