Auto Mobile Inventory Model and Transaction Management A Case Study: Jacar Ltd Ndeeba

ABSTRACT JACAR ltd James Car dealers limited is a Company which is under private Companies dealing in transaction of car, spare parts and Motor cycles. At the district level, JACAR ltd is under Kampala district which is under the private sector. The Company is headed by the Company Manager, His major role is to ensure that the Company is mainstreamed in all development plans. The Company is comprised of four departments namely; • Managing Dept. • Sales Dept. • Purchasing Dept. • Advertising Dept.

TABLE OF CONTENTS

DECLAEATION

SUPERVISOR APPROVAL ii

ACKNOWLEDGEMENT iii

ABSTRACT iv

ACRONYMS v

DEDICATION vi

TABLE OF CONTENTS vii

List of figures x

CHAPTER ONE 1

1.0 Introduction 1

1.1 BACKGROUND 1

1.2 Statement of the Problem 1

1.3. Objectives of the study 2

1.3.1 Main objectives 2

1.3.2 Specific Objective 2

1.4 The Scope of the Study; 2

1.5 Significance of the project 3

1.7 Conclusion 3

CHAPTER TWO 4

LITERATURE REVIEW 4

2.0 Introduction 4

2.1 The importance of an Inventory model and transaction management System 4

2.2 Information Technology 5

2.3 The concept of a System Development Life Cycle (SDLC) 6

2.4 Prototyping 7

2.5 Data as a Corporate Asset 7

2.6 The concept of database system environment 7

2.7 Previous studies 8

2.7.1DBMS 8

2.7.2The advantages of DBMS are as follows 8

2.7.3 Disadvantages of DBMS 9

2.8 Structured Query Language (SQL) 9

2.8.1 It has the following advantages 9

2.8.2 However, SQL has the following limitations 9

2.9 DATABASE SECURITY 10

2.9.1 Countermeasures — computer-based controls 10

2.9.2 Redundant array of independent disks (RAID) 11

2.10 VisualBaSic~

2.11B~CODE 12

2.11.1 BenefitS! reasons of using barcodes 12

2.12B~C0DERE~~ 13

2 l2OAbarcoderea~ 13

2.12.1 Methods 13

2.12.2 D imaging scanners 14

2.13 Conclusion 15

CHAPTER THREE 16

METHODOLOGY 16

3.0 ffitroduction 16

3.1 Research Methodology 16

3.1.1 Target Population 16

3.1.2 Sample selection 16

3.1.3 Research proced~e 16

3.1.4 Data collection 17

3.1.5 Data collection tools 17

3.1.5.1 Questionnaire 17

3.1.5.2 JntervieWing~ 18

3.1.5.4 Documefltati0~Y 18

3.2 Data Analysis and Development of a prototype 19

3.3 Kind of information to be stored 19

3.4 Development Methodology and Tools 20

3.6 Tools 20

3.7 System Desi~ 20

3.6.1 Logical desi~ 21

3.6.1.1 Entity RelationslMP Dia~am 21

3.6.1.2 Basic concepts about entity relationship model (E-R model) 21

3.6.2 Physical Design 23

3.7.1 System Request 25

3.7.2 Name of the project 25

3.7.3 Name of the organization 25

3.7.4 Business needs of the organization 25

3.7.5 Expected functionality of the system 25

3.7.6 Expected value of the system 26

3.8 Feasibility Analysis 26

3.8.1 Economic feas1b1~-’~Y 26

3.8.2 intangible benefits 26

3.8.3 OrganizatiOn feasibility 27

3.9 Risk assessment .27

3.10 Conclusion 27

CHAPTER FOUR 28

REPRESENTATION OF THE FINDINGS AND SYSTEM DESIGN 28

4.0 Introduction 28

4.2 User Interface 28

4.3 The new computerized system 31

4.3.1 THE DATA FLOW MDIAGRAM 33

CHAPTER FIVE

SYSTEM IMPLEMENTATION

5.1 Introduction

5.2 Unit Testing

5.3 System Conversion 37

5.4 User training 37

5.5 Conclusion

CHAPTER SIX 38

EVALUATION, RECOMMENDATIONS AND CONCLUSION 38

6.1 Introduction 38

6.2 Evaluation of the new system 38

6.3 Limitations of the study 38

6.4 RecommendatiOn 39

6.5 Conclusion 40

REFERENCE 41

APPENDIX A 42

A sample questionnaire 42

APPENDIX B 46

Source code for the MDI foiin 46

APPENDIX C 59

Definition of some terms 59