Development of relational data base management information system on integrated farming

Data base information system for integrated farming

Authors

  • MANIBHUSHAN ICAR Research Complex for Eastern Region, Patna
  • ASHUTOSH UPADHYAYA ICAR Research Complex for Eastern Region, Patna
  • ANIL KUMAR SINGH ICAR Research Complex for Eastern Region, Patna
  • SANJEEV KUMAR ICAR Research Complex for Eastern Region, Patna
  • AKRAM AHMED ICAR Research Complex for Eastern Region, Patna
  • ARTI KUMARI ICAR Research Complex for Eastern Region, Patna

DOI:

https://doi.org/10.21921/jas.v9i04.%2011600

Keywords:

MySQL, PHP, JavaScript, graphical user interfaces , integrated farming system , data base management

Abstract

Management information system on integrated farming has been developed using MySQL, PHPand JavaScript. It was tested with farmer’s field data in Mirzapur village, Nalanda, Bihar, and shown to be suitable for land allocation among various components of the integrated farming system (IFS), calculation of production cost, gross income, net income, family food demand, and so on. User login and password are used to access this information system. As a result, it is completely secure and can only be accessed by authorised users. MySQL is used to generate databases, whereas PHP and JavaScript are used to create graphical user interfaces (GUIs) and connectivity to the database. Crop, horticulture, livestock, fishand goat are the key components of IFS of 2 acre model in Mirzapur village.He allotted 1.25 acre to crop, 0.48 acre to horticulture crop, 0.01 acre to livestock, 0.01 acre to goat, and 0.25 acre to fish in his 2-acre model. The gross income is Rs.506350 and the manufacturing cost is Rs.279510. The optimum net income from this model is Rs. 267720 when the land allocation is optimised utilising this information system and reallocated as 1.1 acre in crop, 0.48 acre in horticultural crop, 0.01 acre in livestock, 0.015 acre in goat, and 0.395 acre in fish. This is due to fact that the goat and fish components provide greater income than the crop, net income is enhanced by Rs.40880. As a result, if the land allocation is optimised, the income increases by 18%. Farmers may find this information valuable in allocating land among different components to maximise income from their IFS model-based farming.

Author Biographies

MANIBHUSHAN, ICAR Research Complex for Eastern Region, Patna

Senior Scientist, Divison of Land and Water Management

ASHUTOSH UPADHYAYA, ICAR Research Complex for Eastern Region, Patna

Head and Director(A), Division of Land and Water Management

ANIL KUMAR SINGH, ICAR Research Complex for Eastern Region, Patna

Principal Scientist, Division of Land and Water Management

SANJEEV KUMAR, ICAR Research Complex for Eastern Region, Patna

Principal Scientist, Division of Crop Research

AKRAM AHMED, ICAR Research Complex for Eastern Region, Patna

Scientist (SS), Division of Land and Water Management

ARTI KUMARI, ICAR Research Complex for Eastern Region, Patna

SCIENTIST, Division of Land & Water Management  

References

Beek J. 1978.Land evaluation for agriculture development ILRI. Publication 23. Wageningen

Demiryurek K, Erdem H, Ceyhan V, Atasever S and Uysal O. 2008. Agricultural information systems and communication networks: the case of dairy farmers in Samsun province of Turkey. Information Research, 13(2) paper 343. [Available at http://InformationR.net/ir/13-2/paper343.html].

Faridah A. 2001. Sustainable agricultural system in Malaysia. Paper presented at Regional Workshop on Integrated Plant Nutrition System (IPNS), Development in Rural Poverty Alleviation, 18-20 September 2001, United Nations Conference Complex, Bangkok, Thailand.

FAO. 1983. Guidelines: Land evaluation for rainfed agriculture Soils Bulletin 52. Food and Agriculture Organisation of the United Nations, Rome

Manibhushan and Ahmed Akram. 2019. Spatial analysis of water resources data in selected district of Bihar, Journal of AgriSearch, 6(3):134-138.

Maningas R V, Perez V O, Macaraig A J, Alesna W T and Villagonzalo J. 2005. Electronic Information Dissemination through the Farmers Information and Technology Services (FITS)/Techno Pinoy Program. Bringing Information and Technology within the Reach of the Farmers. From http://jsai.or.jp/afita/afita-conf/2000/part08/p231.pdf, 2000.

Ojeda-Trejo, Enrique. 1997. E. Land Evaluation and Geographical Information Systems for Land Use Planning.

Pillay TVR. 1990. Aquaculture: Principles and Practices. Fishing News Books, London.526-542.

Roling NG.1988. Extension science: information system in agricultural development. Cambridge: Cambridge University Press

Vincke M.1991. Integrated Farming on Fish and Livestock: Present Status and Future Development,

Downloads

Published

2023-06-28

Most read articles by the same author(s)

> >>