DESIGN AND IMPLEMENTATION OF A COMPUTERIZED FARM MANAGEMENT INFORMATION SYSTEM

ABSRTACT     

Accurate and easy to use Farm Management Information  Systems (FMIS) areof  fundamental  importance  for  a  successful  operational  farm  management.However, still today many farmers do not use FMISs for various reasons, like lackof knowledge and the complexity of many available FMISs. In particular for smallto  medium-sized  farms  and  for  multifunctional  farms  appropriate  FMISs  hardlyexist.This  research  project  work  aims  on  the  deduction  of  a  FMIS.  The  FMIS  has  tofocus  on  the  needs  of  medium-sized  and  multifunctional  farms.  Therefore,  SidiMamman  farm  was  picked  as  a  case-study  to  apply  a  system analysis.  The  casestudy  farm  helps  to  identify  and  to  analyze  relevant  material  and  informationflows, production processes, and their interconnections and synergies.The design was taken in order to make the organization’s activities more effectiveand efficient to increase performance by making farm record and information saferand faster in retrieving such information. The problems were identified after seriesof interviews and observation after which analysis was made and a computerizedsystem  was  recommended.  The  new  system  was  designed  using  PHP,  VisualBasic, and MySQL as database.

TABLE OF CONTENT

TITLE PAGE………………………………………………………………I

CERTIFICATION PAGE………………………………………..……….I

DEDICATION……………………………………………………………IIIACKNOWLEDGEMENT………………………………………………...IV

ABSTRACT………………………………………………………………..V

TABLE OF CONTENTS…………………………………………………..VI

CHAPTER ONE……………………………………………………………1

INTRODUCTION………………………………………………………….1

1.1 BACKGROUND OF THE STUDY………………………………..1

1.2 STATEMENT OF THE PROBLEMS………………………………3

1.3 AIM AND OBJECTIVES OF THE STUDY………………………..4

1.4  SIGNIFICANCE OF THE STUDY………………………………....5

1.5 SCOPE AND DELIMITATION OF THE STUDY…………………6

1.6 DEFINITION OF OPERATIONAL TERMS……………………….6

CHAPTER TWO: REVIEW OF RELATED LITERATURE……………….7

2.1 FARM MANAGEMENT INFORMATION SYSTEM………………7

2.2 INFORMATION SYSTEM…………………………………………..9

2.3 FUNCTIONS OF INFORMATION SYSTEM…………………….....10

2.4 TYPES OF INFORMATION SYSTEMS……………………………..12

2.5  MANAGEMENT INFORMATION SYSTEM……………………….14

2.6 BENEFITS OF MANAGEMENT INFORMATION SYSTEM………16

2.7  COMPONENT OF A DATABASE MANAGEMENT SYSTEM…….17

CHAPTER THREE…………………………………………………………….19

SYSTEM ANALYSIS AND DESIGN………………………………………...19#

3.1  INTRODUCTION……………………………………………………...19

3.2  ANALYSIS OF EXISTING SYSTEM AND DESIGN………………..21

3.3  WEAKNESS OF THE EXISTING SYSTEM………………………….21

3.4  DATA COLLLECTION………………………………………………..22

3.5  ANALYSIS OF THE PROPOSED SYSTEM………………………….23

3.5.1  ALGORITHM………………………………………………………….24

3.6 DATABASE DESIGN…………………………………………………27

DATE 27FOLLOW-UP NOTES………………………………………………………….27

CHAPTER FOUR………………………………………………………………29

IMPLEMENTATION AND EVALUATION………………………………….29

4.1 PROGRAM DEVELOPMENT…………………………………………29

4.1.1  DESIGN STANDARD………………………………………………….29

4.1.2 OUTPUT SPECIFICATION AND DESIGN……………………………..29

4.1.3  INPUT DESIGN AND SPECIFICATION……………………………..30

4.1.4 FEED RECORD SHEET – FR…………………………………………..30

4.1.5 RECORD OF DISEASE OCCURRENCES IN HERD – RDD…………30

4.1.6 INPUT PURCHASE RECORDS – IPR…………………………………31

4.1.7 PESTICIDE APPLICATION RECORDS – PA…………………………31

4.1.8 SALES RECORDS – SR………………………………………………...32

4.1.9 STAFF EMPLOYMENT FORM………………………………………..32

4.1.10FILE DESIGN…………………………………………………………..33

4.2 SYSTEM REQUIREMENTS…………………………………………..33

4.2.1 SOFTWARE REQUIREMENTS…………………………………………33

4.2.2 HARDWARE REQUIREMENTS………………………………………33

4.3 SYSTEM INTERFACE………………………………………………….33#

4.3.1 INPUT INTERFACE…………………………………………………….34

4.3.2 OUTPUT INTERFACE…………………………………………………36

4.4 SYSTEM PERFORMANCE……………………………………………38

4.5 SYSTEM TRAINING…………………………………………………..3

4.6 CONVERSION TO THE PROPOSED SYSTEM………………………39

4.7 SYSTEM DOCUMENTATION…………………………………………40

4.7.1 OPERATIONAL MANNUAL………………………………………….40

4.7.2 USER’S MANUAL……………………………………………………..40

4.8 SYSTEM MAINTENANCE……………………………………………41

CHAPTER FIVE:SUMMARY

5.1 SUMMARY…………………………………………………………….42

5.2 RECOMMENDATIONS……………………………………………….42

5.3 CONCLUSION…………………………………………….…………48

REFERENCEAPPENDIX……………………………………………………………………..45

Source codes