Development of relational data base management information system on integrated farming

Data base information system for integrated farming

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.