Central Evidence Zambia

Problem description and objective specification

The aim is to create an information system for the Central Identification of cattle in Zambia. The system will be simple and sturdy enough, with respect to the specific area of implementation.

Analysis and suggested solution

The system will be runned on a database server. The server will contain a web interface and a web service for the communication with mobile data acquisitions (tablets).
It will be possible to enter the data about the particular animals, farmers and inseminations directly throug the web or through the tablets.
Each data record in the system will have its own picture/copy on the pre-printed paper card. The card will serve as an initial form for data collection. Cards will be kept by the farmer, data from the cards will be transferred to the information system (tablet, web). Each card will have its own unique identification number, which will also be the database key in the corresponding table of Central Identification.
Empty cards with the unique numbers will be printed out from the information system. Each AI technician will have his own assigned set of numbers intended only for his use.
Each AI technician working with the system will own a tablet with a mobile application, which will allow him to enter the data from the cards to the system. Data will be entered to the system durin the off-line regime and will be sended to the server once the AI technician reaches the place with availavle internet connection.

Basic functions of the Information System
Mutual functions for the tablets and the web application:

1) Establishment and data update of a new farmer

  • The database will register these information about each farmer:
    CH7 (seven digit identification number), name, address, street, town, ZIP code, closer identification and GPS coordinates.
  • Same information will be recorded in the farmer’s identification card.
  • There will be a list of animals registered under each farmer.

2) Establishment and data update of the animal identification card

  • For each animal the database will refister following data:
    ear tag number (ZAM+15 digit number), Brand (local farmer’s identification), day-month-year of birth (at least a year), identification number of mother, identification number of father, number of the farmer, the recording date, name of AI technician, note, breed.
  • Same information will be recorded in the animal’s identification card.
  • There will be the list of insemination registered for each animal.

3) Insemination record

  • The database will register these information about each insemination:
    date of insemination, farm/farmer, number of animal, number of bull, insemination order, technology, date of calving.
  • Functions of web application.

4) Card printing

  • Print of cards with the unique numbers for each technician.

5) Reporting

  • Report creation – animals, farmers, inseminations, etc.

6) Administration

  • Administrator – sets the ranges of the cards, prints out the cards, assigns permitions.
  • Technician – data entry and checking.

System architecture

Architecture of the information system:

image002

 

 

 

 

 

 

 

 

 

Used technologies:

  • Databse – MS SQL Server
  • Web interface – .NET ASP
  • Mobile client – Android (Air)