Design And Implementation Of Categorized Student Result Management Information System Case Study: Mbarara University

TABLE OF CONTENTS

DECLARATION

APPROVAL H

ACKNOWLEDGEMENT

LIST OF TABLES IV

CHAPTER ONE ~1

l.OBACKGR0uND 1

1.ISTATEMENT TO THE PROBLEM 1

1.2 GENERAL OBJEcTIvE 1

1.3 SPECIFIC OBJECTIvE5 2

1.4 REsEARCH QuEsTIoNs~ 2

1.5 SCOPE OF THE PROJECT 2

1.6 SIGNIFICANCE OF THE STUDY 2

CHAPTER TWO 5

LITERATURE REVIEW 5

2.1 INTRoDuCTIoN 5

2.2 INFORMATION TECHNOLOGY (IT) 5

2.3A5Y5TEM 6

2.4 AN INFORMATION SYSTEM (IS) 6

2.5 FILE PROCESSING AND MANUAL SYSTEM 7

2.6 ADATABASE(DB) 9

2.6.1 ADvANTAGES OF DATABASE 9

2.6.2 DISADvANTAGES OF DATABASE APPROACH 10

2.7 DATABASE MANAGEMENT SYSTEMS (DBMS) 11

2.7.1 COMPONENTS OF A DATA BASE MANAGEMENT SYSTEM 12

13

RESEARCH METHODOLOGY._.,~13

3.1 INTRODUCTION 13

3.2 RESEARCH DESIGN 13

3.3 PRoJECT AREA 13

3.4 PoPuLATioN DESCRIPTION 14

3.5 SAMPLING PROCEDURES 14

3.6 DATA COLLECTION METHODS 14

3.6.1 INTERvIEwS 14

3.6.2 OBSERvATIONS 14

3.6.3 QUESTIoNNAIRES 15

3.7 DEvELoPMENT TOOLS 15

3.7.1 SOFTWARE REQUIREMENTS 16

V

CHAPTER~ .._..__~..... 17

SYSTEM ANALYSIS AND~~17

4.OINTR0DuCTI0N 17

4.1 SHORTCOMING OF THE EXISTING SYSTEM 17

4.2 SYsTEM ANALYSIS 17

4.2.1 CuRRENT OR ExIsTING SYSTEM 18

4.2.1.1 FEATuREs OF THE CURRENT SYSTEM 18

4.2.1.1 FEASIBILiTY STUDY OF THE CURRENT SYSTEM 19

4.3 TECHNICAL FEASIBILITY 19

4.3.1 ECONOMIC FEASIBILITY 20

4.3.2 OPERATIONAL FEASIBILITY 21

4.4 FEASIBILITY STUDY OF THE NEW SYSTEM 21

4.5 DESIGN OF THE NEW SYSTEM 22

4.5.1 CONCEPTUAL DESIGN 22

4.5.2 LOGICAL DESIGN 23

4.5.3 PHYSICAL DESIGN 23

4.6 ENTITY RELATIONSHIP MODEL (ER DIAGRAM) 23

4.7 DATA STRUCTURES 24

4.8 SYSTEM MAINTENANCE AND SECURITY 29

4.8.1MAINTENANCE~ 29

4.9 SECURITY CONTROLS 29

4.9.1 PHYSICAL CONTROLS 29

4.9.2ELECTR0NIC CONTROLS 29

4.9.3S0FTwARE CONTROLS 29

4.9.4MANAGEMENT CONTROLS 30

4.9.5COMM0N THREATS 30

4.10 IMPLEMENTATION AND TESTING 30

4.10.1 CODING 30

4.10.2 TESTING 30

4.9.3 UNIT TESTING 31

4.10.3 INTEGRATION TESTING 31

4.10.4 SYSTEM TESTING AND IMPLEMENTATION 31

4.11 EVALUATION 33

4.11.1 INTRODUCTION 33

4.11.2ADATAENTRY 33

4.11.3 FUTURE EXPANSION AND DEVELOPMENT OF THE SYSTEM 33

4.11.4 CHALLENGES ENCOUNTERED DURING PROJECT DEVELOPMENT 33

4.12 SCREEN SHOTS OF DESIGN OF ENHANCED EMPLOYEE MANAGEMENT INFORMATION

SYSTEM 33