Development of Database Management System for Selected Commercial Crops
Loading...
Date
2016-06
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
University of Agricultural Science, Dharwad
Abstract
A study was carried out on development of database management system in Dharwad district for chilli (Capsicum annuum) and potato (Solanum tuberosum) crop using secondary data of about twenty years from 1991 to 2010. Transitional probability matrix was used to study the shift in area of selected crops. Highest shift was found in chilli crop (93 %) followed by cotton and sunflower crop (92 % and 70 % respectively). Multiple regression analysis for the study of influence of climatic factors on production of selected commercial crops revealed that maximum temperature, minimum temperature and relative humidity (morning) were significant for chilli production with R2 value 71.7 per cent and only maximum temperature was found significant for potato crop production with R2 value 36.1 per cent. Coppocks instability index showed highest instability for productivity of chilli crop (117.54 %) and production in potato crop (145.75 %).
The database management system is designed with an objective of providing solutions to the crop related problems which has additional platform for interaction between source updater and end users for their queries. It’s mainly used to provide agriculture extension services to farmers and to transfer the latest technical knowledge to the farming community, so that the overall agricultural production will be increased over district. The database management system has been developed in the MySQL database and server type hardware. Name of the webpage is given as “KRUISHIDHAMA”, which contain detailed information about package of practice i.e. origin, introduction, botany, seeds, sowing, varieties, pests, diseases, weed and water management & harvesting of selected commercial crops grown in Dharwad. This tool provides necessary information to farmers, administrator, agriculture extension workers, researchers and students.