11: Introduction

AN Database Documentation
ADDITIONAL CONTENT REQUIRED

Introduction

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 in kind;
  2. Data Tables, which are the data source for the front end database.

 
The following diagram illustrates the relationships between the various components:
schema
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 and remains as a unit 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.
Characteristics of a household include its address, quality of accommodation and living expenses. With the exception of the household reference, all the characteristics of a household may be revised as family circumstances change.

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 health, education and employment details.

Donations:
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

Notes
None.
Outstanding Issues
Refer to the attached comments below

.
~~~~~~~~[EoF]
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, 09/Nov/2022: © Asociatia Umanitara Neemia