DESIGN AND IMPLEMENTATION OF AN ONLI1~E DISTRIBUTED TRANSACTION SYSTEM FOR MIJKWANO GROUP OF I1~DUSTRIES, KAMPALA

ABSTRACT

This project described the entire process for designing an Online Distributed Transaction System. The main objective for this project was to analyze and developing an online transaction system that can enable the company to sale goods online and to widen the market base of the Company, which was designed and implemented.

This Project was about Designing and implementing an Online Distributed Transaction System for Mukwano Industry. The project gave analysis of the old system that was manual. All the above imply that the system will run smoothly thereby reducing on the workload, increase productivity and improve efficiency on the current system.

The development methodology and tools have also been discussed in details. These include knowledge acquisition and analysis, data collection techniques, development tools and system validation. Details of the new designed system, like system specification, user interfaces and Class diagrams for the new system are discussed. The system testing, data conversion and loading, approaches of implementations of a new system, user training and manuals system validation details are also discussed.

However as was stated, due to time constraint the system does not consider all the areas. The system has not gone through the stage of maintenance because this is a proto type. The software doesn’t have the HELP function; therefore individual learning will be a bit hard to master the operation of the system.

TABLE OF CONTENTS

APPROVAL

ACKNOWLEDGEMENT iv

LIST OF ABBREVIATIONS v

LIST OF FIGURES Vi

LIST OF TABLES

TABLE OF CONTENTS viii

ABSTRACT X

CHAPTER ONE 1

1 .Olntroduction 1

1.1 Background of the study 1

1.2 Problem Statement 2

1.3 Purpose of the study 2

1.3.1 Specific Objectives 2

1.4 Significance 2

1.5 Project Scope 2

1.6 Limitations

CHAPTER TWO 3

2.Olntroduction 4

2.1 Database systems 4

2.2 User and system requirement 5

2.4 Conclusion

CHAPTER THREE 8

3.Olntroduction 8

3.1 System study and investigation 8

3.1.1 Instruments 8

3.2 System Analysis 8

3.2.1 Existing System to be critically analyzed 8

VI I

3.3.1 User Requirements will be ascertained 9

3.3.2 Functional requirement 10

3.3.3 Non-functional Requirements 10

(i) Software Requirements 10

(ii) Hardware Requirements 11

3.4 System Design 11

3.4.1 Data Flow Diagram will be used 11

3.4.2 Class Diagrams 11

3.5 System Implementation 12

3.5.1 MySQL 12

3.5.2 Dream Weaver 12

3.5.3 Training 12