Yasmine Ghandour (1*),Mahmood Alio(1) and Omar Farousi (1)
(1). Dep. Agricultural Economics., Fac. Agric., Tishreen Univ., Lattakia, Syria.
(*Corresponding author: Eng. Yasmine Ghandour. E-mail: sisialamera121212@gmail.com).
Received: 23/11/2020 Accepted: 24/02/2021
Abstract
The aim of the research is to establish an integrated database for poultry layers farms in the coastal region of Syria, focusing on the Jeriemquia poultry farm as a case study. Where the research was carried out by relying on a field questionnaire with the aim of identifying the technical characteristics of the poultry farm and all the production and marketing processes of the poultry for the production cycle 2018-2019. The research relied on comparing the results of the descriptive analysis of financial indicators with their value resulted from the database analysis to shed light on the most important features of the database compared to traditional methods of records management. Access 2010 was used to design and build the desired database. The results showed that the resulting database was characterized by flexibility and the ability to relate the basic variables to each other. According to this rule, the health indicators of the herd were monitored, the most important of which was the total mortality rate, which amounted to about 4.7% on average during the production cycle. The weekly consumption of feed from 70-750g / bird is an average of 620g / bird per week. Likewise, with regard to egg production, as the total egg production of the studied flock reached 16.5 million eggs. Taking in consideration the flock size that estimated at 60 thousand birds at the beginning of the period, the average productivity of the bird in the studied poultry reached 326 eggs / production cycle, with an average of 60.3 grams per egg. As for the financial analysis, the characteristics of the logical database were used to build relationships and inquiries in order to calculate costs and revenues, as it was found that the studied poultry farm was able to achieve net revenues from one production cycle estimated at about 26.4 million SP. This is mainly due to the ability of the domesticated animal to obtain basic fodder and some other inputs from government institutions at reduced prices compared to the market. As the total costs of one production cycle in this farmhouse were about 515.8 million SP. The cost of feed was the most important item by 82.3%, followed by the value of chicks by 4.1%, then fuel and veterinary medicinal materials at a rate of 3.7 and 3.3% for each, respectively.
Key words: database, poultry layers, table eggs, ACCESS Database.
Full paper in Arabic: pdf