PROJECT REPORT
EXAM CARD APPLICATION SYSTEM
CASE STUDY OF SIKIRI TECHNICAL AND VOCATIONAL
COLLAGE
NAME:
INDEX NUMBER:
INSTITUTION: KISII NATIONAL POLYTECHNIC
SUPERVISOR:
SUBMITTED TO THE KENYA NATIONAL COUNCIL OF
EXAMINATON FOR THE AWARD OF DIPLOMA IN
INFORMATION COMMUNICATION AND TECHNOLOGY
NOVEMBER 2023
i
, DECLARATION
This Project Report is original and has not been submitted or published previously for any other
Degree or Diploma Award to any other institution before.
Name:
Date:
Sign
This is to confirm that this research report is produced under my supervision
Name:
Supervisor
Date:
, DEDICATION
To my sister who facilitated me all through unconditionally plus my parents and to all my family
members for the love and care. I cherish u all. Please keep up the spirit. May God bless u.
To my dear parents who have supported me financially and giving me the guidance throughout my
stay at the university, my brothers and sisters for their assistance in various ways, and finally to the
almighty God who has blessed me abundantly.
iii
, ACKNOWLEDGEMENT
I take this opportunity to thank God who was always with me and also provided the
knowledge, wisdom and skills that have enabled me to complete this project.
I would like to extend our sincere gratitude to our supervisor, for sparing time and effort to
offer extraordinary assistance, advice and support through this great undertaking. Thank you
so much.
iv
, ABBREVIATIONS
ICT Information and Communication Technology
IT Information technology
RMS Record Management System
ISO International Standards Organization
DBMS Database Management System
EERDs - Enhanced Entity Relationship Diagrams
DFDs Data Flow Diagrams
HTML Hypertext markup language
CSS Cascading style Sheets
SQL Structured Query Language
v
, ABSTRACT
For over half a century, Population Studies have reported significant advances in methods of
demographic analysis. conceptual and mathematical theories of demographic dynamics and
behavior, and the use of these theories and methods to extend scientific knowledge and to
inform policy and practice.
Most low developing collages are facing a number of problems in exam card processing and
production these include; bureaucracy, bribery, corruption, forgery, security and poor
records management which is currently done manually. This makes the processing of
documents slow and more hectic. Therefore, the collages need to come up with an
automated exam card records management system to help reduce these problems through
embracing information and communication technology (ICT).
Therefore there is need to carry out research so as to come out with a secure and a more
effective automated system to streamline some business processes such as registration and
applications to improve efficiency, enhance planning and decision making
An Automated Online Exams Application System is an Information System that serves to
capture, store, retrieve and disseminate information about exams, process cards and records
management in the office of the collage It offers a means of information sharing as well as
automating the existing manually driven record keeping facility.
vi
, Contents
DECLARATION.......................................................................................................................ii
DEDICATION..........................................................................................................................iii
ACKNOWLEDGEMENT.......................................................................................................iv
ABBREVIATIONS...................................................................................................................v
ABSTRACT.............................................................................................................................vi
vii
List of figures.........................................................................................................................x
x
list of tables...........................................................................................................................xi
CHAPTER ONE.........................................................................................................................1
1.1 Background of The Study.............................................................................................1
1.2 problem Statement........................................................................................................1
1.3 Objectives.....................................................................................................................2
1.3.1general Objectives......................................................................................................2
1.3.2specific Objectives.....................................................................................................2
1.4 Research Questions......................................................................................................2
1.5 scope.............................................................................................................................2
1.6 Justification..................................................................................................................3
1.7 Significance of The Study............................................................................................3
CHAPTER TWO........................................................................................................................4
LITERATURE REVIEW......................................................................................................4
2.0 Introduction..................................................................................................................4
2.2 Types of Record Management.....................................................................................5
2.2.0 Manual Record Management....................................................................................5
2.2.1 Problems Associated with Manual Records Management System...........................5
2.2.2 Online Records Management System.......................................................................6
2.2.3 Web based information systems................................................................................6
2.3 Databases......................................................................................................................6
2.3.1 The Architecture of Web Based Databases...............................................................7
2.4 The Case for Web Based Systems................................................................................7
vii
EXAM CARD APPLICATION SYSTEM
CASE STUDY OF SIKIRI TECHNICAL AND VOCATIONAL
COLLAGE
NAME:
INDEX NUMBER:
INSTITUTION: KISII NATIONAL POLYTECHNIC
SUPERVISOR:
SUBMITTED TO THE KENYA NATIONAL COUNCIL OF
EXAMINATON FOR THE AWARD OF DIPLOMA IN
INFORMATION COMMUNICATION AND TECHNOLOGY
NOVEMBER 2023
i
, DECLARATION
This Project Report is original and has not been submitted or published previously for any other
Degree or Diploma Award to any other institution before.
Name:
Date:
Sign
This is to confirm that this research report is produced under my supervision
Name:
Supervisor
Date:
, DEDICATION
To my sister who facilitated me all through unconditionally plus my parents and to all my family
members for the love and care. I cherish u all. Please keep up the spirit. May God bless u.
To my dear parents who have supported me financially and giving me the guidance throughout my
stay at the university, my brothers and sisters for their assistance in various ways, and finally to the
almighty God who has blessed me abundantly.
iii
, ACKNOWLEDGEMENT
I take this opportunity to thank God who was always with me and also provided the
knowledge, wisdom and skills that have enabled me to complete this project.
I would like to extend our sincere gratitude to our supervisor, for sparing time and effort to
offer extraordinary assistance, advice and support through this great undertaking. Thank you
so much.
iv
, ABBREVIATIONS
ICT Information and Communication Technology
IT Information technology
RMS Record Management System
ISO International Standards Organization
DBMS Database Management System
EERDs - Enhanced Entity Relationship Diagrams
DFDs Data Flow Diagrams
HTML Hypertext markup language
CSS Cascading style Sheets
SQL Structured Query Language
v
, ABSTRACT
For over half a century, Population Studies have reported significant advances in methods of
demographic analysis. conceptual and mathematical theories of demographic dynamics and
behavior, and the use of these theories and methods to extend scientific knowledge and to
inform policy and practice.
Most low developing collages are facing a number of problems in exam card processing and
production these include; bureaucracy, bribery, corruption, forgery, security and poor
records management which is currently done manually. This makes the processing of
documents slow and more hectic. Therefore, the collages need to come up with an
automated exam card records management system to help reduce these problems through
embracing information and communication technology (ICT).
Therefore there is need to carry out research so as to come out with a secure and a more
effective automated system to streamline some business processes such as registration and
applications to improve efficiency, enhance planning and decision making
An Automated Online Exams Application System is an Information System that serves to
capture, store, retrieve and disseminate information about exams, process cards and records
management in the office of the collage It offers a means of information sharing as well as
automating the existing manually driven record keeping facility.
vi
, Contents
DECLARATION.......................................................................................................................ii
DEDICATION..........................................................................................................................iii
ACKNOWLEDGEMENT.......................................................................................................iv
ABBREVIATIONS...................................................................................................................v
ABSTRACT.............................................................................................................................vi
vii
List of figures.........................................................................................................................x
x
list of tables...........................................................................................................................xi
CHAPTER ONE.........................................................................................................................1
1.1 Background of The Study.............................................................................................1
1.2 problem Statement........................................................................................................1
1.3 Objectives.....................................................................................................................2
1.3.1general Objectives......................................................................................................2
1.3.2specific Objectives.....................................................................................................2
1.4 Research Questions......................................................................................................2
1.5 scope.............................................................................................................................2
1.6 Justification..................................................................................................................3
1.7 Significance of The Study............................................................................................3
CHAPTER TWO........................................................................................................................4
LITERATURE REVIEW......................................................................................................4
2.0 Introduction..................................................................................................................4
2.2 Types of Record Management.....................................................................................5
2.2.0 Manual Record Management....................................................................................5
2.2.1 Problems Associated with Manual Records Management System...........................5
2.2.2 Online Records Management System.......................................................................6
2.2.3 Web based information systems................................................................................6
2.3 Databases......................................................................................................................6
2.3.1 The Architecture of Web Based Databases...............................................................7
2.4 The Case for Web Based Systems................................................................................7
vii
