Database Management System For Nursing Schools Case Study: Kyamuhunga Nursing School

ABSTRACT

This project report is about a database management information system for Kyamuhunga Nursing School used as a case study.

The school was partially running its activities manually and this had numerous short comes most important being lack of security in storing files, loss of virtual information

and tiresome for data entrants.

The project report was a combination of qualitative and quantitative methods. The Researchers employed questionnaire, observation and reviews of documents as data collection methods.

The challenge was to automate complaints to overcome the above short comes, Microsoft access is used for back-end application and Microsoft visual basic for front-end application are used to develop the system that could solve the problem.

In the developing the system, system implementation are considered. A database system can be considered to achieve most of the objectives, and the general project goal of this project is to design and establish a computer-based management information system for easy input, processing, storage, monitoring, and access to information within the store

TABLE OF CONTENTS

DECLARATION II

APPROVAL III

DEDICATION Iv

ACKNOWLEDGEMENT v

TABLE OF CONTENTS vI

ABSTRACT xi

ABBREVIATIONS AND ACRYNOMS XII

CHAPTER ONE 1

1.1 Background of the study i

1.2 Problem statement 2

1 .3 Objectives 3

1.3.1 General objective 3

1.3.2 Specific objectives 3

1.4 Scope of the study 3

1.5 Significance of the study 3

1.6 Limitations of the study 4

CHAPTER TWO

Literature review s

2.1 Overview 5

2.1.1 Information technology 5

vi

2.2 Information system .6

2.2.1 Management information system (mis) 6

2.2.2 Functional information system(fis) 7

2.2.3 Office automation system (oas) 8

2.2.4 Transaction processing system (tps) 8

2.2.5 Decision support system 9

2.2.6 Expert systems (es) 10

2.2.7 Database system 11

2.2.8 Relational database 11

2.2.9 Database management system 1 1

2.2.10 Redesigning databases 12

CHAPTER THREE 14

METHODOLOGY 14

3.1 Overview 14

3. 2 System study 14

3.2.1 Methods of data collections 14

3.2.1.1 Literature reading~ 14

3.2.1.2 Interviews~ 14

3.2.1.3 Direct observation 14

3.2.1.4 Questionnaires and their analysis 15

CHAPTER FOUR 16

SYSTEM ANALYSIS AND DESIGN 16

4.1 Overview 16

vii

4.1.1 Shortcoming of the existingsystem.16

4.2 System analysis 16

4.2,1 Current or existing system 17

4.2.1.1 Features of the current system 17

4.2.1.1 Feasibility study of the current system 18

4.1.1 Technical feasibility 18

4.1.2 Economic feasibility 19

4.1.4 Operational feasibility 19

4.2.2.1. Feasibility study of the new system 20

4.4 Design of the new system 21

4.3.1 Conceptual design 21

4.3.2 Logical design 21

4.3.3 Physical design 22

4.3.4 Entity relationship model (er diagram) 22

4.4 Data structures 23

4.5 Hardware and software requirements table 25

CHAPTER FIVE 26

SYSTEM IMPLEMENTATION 26

5.1 Overview 26

5.1.1 Converting to the new system 26

5.1.2 User interface 26

5.1.3 Execution sequence 27

5.2 Screen shots of kyamuhunga nursing school data base management system 27

viii

CHAPTER SIX .33

SYSTEM MAINTENANCE AND SECURITY 33

6.2 Maintenance’ 33

6.3 Security controls 33

6.3.1 Physical controls 33

6.3.2 Electronic controls 33

6.3.4 Management controls 34

6.3,5 Common threats 34

6.4 Implementation and testing 34

6.4.1 Coding 34

6.4.2 Testing 34

6.4.3 Integration testing 35

6.4.4 System testing and implementation 35

6.5 Evaluation and recommendation 37

6.5.1 Introduction 37

6.5.2 Data entry 37

6.6 Recommendations 37

6.7.1 Observations and comments 37

6.7.2 Suggestions 38

6.7.3 Final remark 38

6.7.4 Future expansion and development of the. system.................................................... 38

6.7.5 Challenges encountered during project development............................................... 39

ix

REFERENCES OR BIBLIOGRAPHY .40

APPENDICES 41

APPENDIX 2: CLICK EVENTS 44