11: Introduction

AN Database Documentation


Text required

Purpose of database

Text required

Database Structure

The AN database suite comprises two principal components:

  1. The aviz database, which contains the means of recording, analysing and reporting records of donations of aid items;
  2. Data tables, which are the data source for the front end database.

The following diagram illustrates the relationships between the various components:
These components are supported by a user manual and developer documentation which have many sections in common and are presented as a single volume compiled in a series of sections and chapters.
As currently configured, the Dorohoi database runs in ACCESS 2003, and it will be necessary to have this software installed on your computer. When the database is installed there will an icon installed on your desktop to run the database directly.

Database Content

Information pertaining to donations to beneficiaries is held in a relational database with three hierarchies: Households, Persons and Donations. Each of these is defined below:

Household: The primary operation unit is the household. A household is defined as being one or more people who are living together as a unit, sharing common facilities and domestic circumstances. They may or may not be legally related.
Each household has a unique reference which is retained throughout the database. Each household unit has a titular head, the Head of Household, who may be either the father or the mother, or a third party (eg grandmother). In practice, these are post holders and need not be the actual biological or adoptive parents of the household. Other members of the household are identified through their relationship with the titular head.
Detailed characteristics of a household including its address, quality of accommodation and living expenses are no longer recorded.

Person: A person equates to a ‘persona fizica’ in the Romanian legal system, and is uniquely identified by their CNP. Each person is required to be a member of a household, although they may in fact be the only registered member of their particular household or they may move from one household to another. Characteristics of a person include their CNP, Buletin and residential locality. Personal data about individuals is no longer recorded.

Text required


Database Documents

The following documents are produced within the aviz database:

  • Fisa de Magazie: The Fisa de Magazie is used to keep a running total of goods held in the warehouse pending donation.

Text required

Other Documents

The following is a list of AN documents which are not planned for inclusion within Phase 1 of the database.

  • Act de Donatie:

Text required

Outstanding Issues
Refer to the attached comments below

Return to Index of Documents


Document URL: https://roafan.org/docs/andbnote11/
pdf file: https://roafan.org/docs/pdf/Section1/ANdbNote11.pdf
Published, 24/Apr/2020: Page updated, 01/Feb/2023: © Asociatia Umanitara Neemia