Table of contents
Declaration II
Approval III
1 INTRODUCTION ~1
1.1. Background of the study~ 1
1.1 Statement of the problem 1
1.2 Objectives of the Study 1
1.2.1 General Objective 1
1.2.2 Specific Objective of the study 1
1.3 Scope of the study 2
1.4 Significance of the study 2
CHAPTER TWO 4
2 LITERITURE REVIEW 4
2.1 Introduction 4
2.2 Mailing Lists 4
2.2.1 Types of Mailing lists 5
2.3 Database system 7
2.3.1 Advantages of Database 8
2.3.2 Database maintenance 9
2.4 Application architecture and Development Process 9
2.5 Database Management Systems 9
2.5.1 Advantages of database Management systems 10
2.5.2 Limitation of Database Management System 11
2.5.3 Characteristics of Database Management systems 12
2.6 Summary 12
CHAPTER THREE 13
3 METHODOLOGY 13
iv
3.1 Introduction .13
3.2 The system Development Life Cycle (SDLC) 12
3.3 Data collection methods 14
3.3.1 Questionnaire 14
3.3.2 Interviews 15
3.4 Programming Languages 19
3.5 Local Design 22
3.5.1 Detailed Design 25
3.5.2 Output Requirements 25
3.5.3Hardcopy 26
3.5.4SoftCopy 26
3.6 Processing Requirements 26
3.7 Operating System 26
3.8 Database Management System 27
3.9 Anti Virus Software 27
3.10 Documentation 27
3.11 Summary 27
CHAPTER FOUR 28
4 SYSTEM ANALYSIS AND DESIGN 28
4.1 Introduction 28
4.2 Document Review 28
4.2.1 Strength of the current system 28
4.2.2 Weakness of the current system 28
4.3 Analysis of the proposed system 29
4.3.1 Benefits of the proposed system 29
4.3.2 Requirement analysis 29
4.4 System design 30
4.4.1E-Rmodel 30
4.4.2 Flow charts 32
4.5 Database design 32
4.5.1 4.1.0 Relational database design 32
V
4.6 GUI Design .33
CHAPTER V 34
5 IMPLEMENTATION TESTING AND EVALUATION 34
5.1 Introduction 34
5.1.1 Graphical user interface 34
5.2 Login system 35
5.2.1 Mails 36
5.2.2 New mail record 36
CHAPTER VI 39
6 DISCUSSION, RECOMMENDATION AND CONCLUSION 39
6.1 Objectives and Aims 39
6.1.1 Management 39
6.2 Further Work 40
6.2.1 System changeover 41
6.2.2 Evaluation of the system 41
7 BIBLIOGRAPHY 42
GENERAL REFERENCES 42
8 APPENDIX A 43
9 APPENDIX B 44
CHAPTER ONE INTRODUCTION 1.1. Background of the study: This project describes the design approach and solution techniques developed for a mailing list manager at the faculty of computer studies of Kampala international university. The problem considered here is the design of a system to assist with the means of communication at the faculty. The design however, anticipates expanding the scope of the problem to accommodate other departments. The solution to the mailing list problem is developed here using hypertext pre processor (PHP), programming language which is a respected technology for webbased applications and allows developers to reach far beyond simple HTML application. We employ an object model which allow for the project to be written efficiently, using standard object-oriented methodologies. The internet has spawned a new need for database that can access via the web. The product developed here takes advantage of this technology.