Knec Project 2014
Knec Project 2014
Match records
Fig.01
    Win-3 points
    Draw-1 point
    Loss-0 point
A penalty card is awarded to a player who violates a football rule, and is recorded against the
player’s name. A win of two points is awarded to a team whose opponent fails to honor a
fixture.At the end of the season 30% of the money collected as registration is awarded to the
best three teams in the ratio 3:2:1 respectively. The best team carries the county’s trophy for
                                   1
the season. The team with the lowest number of penalties in the end of the season is
considered the most disciplined. The three most disciplined teams are awarded a certificate.
The three last disciplined teams are reprimanded.
PRELIMINARY INVESTIGATION
PROBLEM DEFINATION
Being a manual system, management of files has proved to be hard and thus many files end up
getting lost. This usually leads to the need of the various school teams to refresh their details
with the KFL management often. The manual system is not able to provide efficient ways of
registering schools, referees, coaches and players in each team. A lot of data is lost in the
process of input or excess data is also input, esp. during the entry of the school teams where
some may be eliminated.The system’s ability to process any data provided is utterly slow. It
lacks accurate methods of generating and presenting reports since they depend on human
being’s intelligence which is slow.The records also require a secure and efficient back up
system that will protect the system from unauthorized access especially if they contain private
data or information about the organization and its members.The organization therefore needs
an efficient, strong and reliable system to cater for all the above mentioned needs.
                                    2
The new computerized system is aimed at improving the general management of the
organization.
Some of the objectives include:
    Improving the security of the records and files belonging to the organization members.
    Ensuring quick access to the data available.
    Ensuring faster processing of data and the general reports another member’s related
      information.
    Enhancing document searching processes
    Enhancing speed in discovering loopholes in the records department and correcting
      them in time.
    Ensure prevention of data loss by creating better storage devices and backup systems.
Fig.02
                                  3
                                           Budget
                      ITEM                                  COST
      Transport                             Ksh 6,500
      Stationery                            KSh 1,500
      Flash disk                            Ksh 500
      Note book                             Ksh 3,000
      Laptop                                Ksh 37,000
      Allowances                            Ksh 7,000
Methodology
The systems development life cycle is the methodology that will be used for the development
of the proposed system. This model involves stages that are well developed and specifies the
activities to be carried out through out its development.
It will mostly touch on planning and implementation of the entire system at a go. Its design
and coding will involve recent developments in ICT and research from the internet.
The stages include the following:
    i. Information gathering
   ii. Feasibility study
 iii. Requirements specification
  iv. System design
   v. System construction
  vi. System implementation
 vii. Testing
viii. Review and maintenance
                                  4
 Fig.03
Methodology (System development life cycle)
Water fall diagram
Feasibility study
                    Requirements
                    specification
                                        System
                                        design
                                                   System
                                                 construction
                                                                    System
                                                                implementation
                                                                                    Testing,
                                                                                  review and
                                                                                 maintenance
Fig.04
                                    5
DETAILED ANALYSIS
Introduction
This is the part where Collection of facts dealing with the case study is in more detail. This is
done in order to familiarize with the current status of the company and how it manages
information. Analysis here refers to the process of defining something fully and laying down
the facts in an orderly manner. In this case it entails various measures that are taken in order
to understand the system being studied so as to interpret the needs of those involved in such
a system.
It is important to understand the user needs and discover new ways of improving
performances, therefore the need to analyze every detail concerningKabumbu football league.
In so doing one is able to comprehend the needs of every individual present in the
organization. This was achieved through interaction with the employees and the members
through interviews, direct observation and questionnaires. The current system was also
analyzed using data flow diagram (D.F.Ds) general organization structure and context
diagrams.
Feasibility study
This is a test that is carried out to establish the cost and benefits of a new system. It
determines whether benefits of developing the new system will be more than benefits of the
current system and whether once implemented will lead to profits for the organization.
    Economic feasibility
    Technical feasibility
    Operational feasibility
Economic feasibility
This was done to establish whether developing of the new system would be cost effective by
weighing its benefits and implementation cost. The benefits of the proposed system
outweighed the cost of the implementation hence it will be advantageous to the new system.
                                    6
Technical feasibility
This is study aimed at establishing whether the club gets the required software and hardware
and also if the staff was competent with the use of the ICT related devices. After the study it
was established that the organization had the required devices and the hardware and software
were easily available.
Operational feasibility
This establishes the extent to which the users are comfortable or happy with the proposed
new system once developed would be able to provide a comfortable working environment for
the employees. This means that the work load would be greatly reduced thus increasing case
in usage and flexibility in the organization.This new system has the following merits;
Efficiency
The new system is bound to lead to production of quality information effectively without
wasting much energy.
Speed
The system will work at a desirable speed i.e. would be able to produce reburied information
at a fast rate.
Security
Improved measures of security will be used in the new system that will ensure that the data
and the information are safe from unauthorized access.
Reliability
The system will be reliable in that it can produce information any time it is required to with
minimum effort.
Integrity reinforcement
This will ensure that data entered or the information is accurate and complete therefore can
be used for decision making.
User friendly
The new system will be easy for the user to interact with considering that one will be using a
user interface that is easy to manage i.e. GUI (Graphical user interface)
                                    7
Storage and retrieval of information
This will become more efficient since the data will be stored in files that are easily accessible
from the computer.
Data communication
The new system will also implement the use of modern data communication devices. This will
improve data transmission within the organization. This will be achieved through creation of a
local data network. All the above areas were studied carefully and it was established that the
project would be of great use to the organization.
REQUIREMENTS SPECIFICATION
This involves the enlisting of suitable hardware and software for the new system which are
determined by the type of input output and user requirements. The user of the system will
determine or dictate what kind of user requirements should be developed by clearly stating
their requirements or the constraints they face when working with the current manual system.
Functional requirements
Non-functional requirements
User friendliness
The system should be able to interact freely with the user with minimal difficulty. Thorough
analysis should be done.
Reliability
Should be able to be depended upon. This is through ensuring that all the user specification
has been incorporated in the new system and by having a backup that will ensure that all the
data lost is retrieved and the users can actually rely on it for the results.
                                     8
Accuracy
A system is accurate if it can process data at a recommendable speed and that the
information that is timely and relevant.
Viable
A system is viable if it can be able to put into practice or even tested and still work effectively.
It should be able to work according to the user specifications.
Since analysis of the challenges facing the manual system is imperative, I found it necessary to
forge methods of how I would understand these challenges fully hence came up with the
following methods:
          Observation
          Interviews
          Questionnaires
Observation
With the observation we watched closely as the members of the organization went on with
their daily routine at work in order to learn how the system works. This method gave us first
hand information and experience about the problems and the expenses to the system
requirements.
Among other sources, we came across letters to and from the clients who wrote in inquiring
about the organization and how the matches are managed.
The following are some of the letters we came across during our research;
    Letter of enquiry
    Reply letter
Questionnaires were also used in order to get information from some of the places where
physical presence was hectic.
                                    9
                                      Letter of inquiry
                                                                       Precious Blood Kilungu,
Nairobi.
Kenya.
Nairobi.
Kenya.
About a month ago, we found out about your organization. Since managing and organizing for
football matches within the school has proved difficult, tiring and noncompetitive, our school
would love it if you accorded us a chance to join your organization. We believe that this would
greatly improve the student’s performance in such a sport, besides nurturing their talent.
We would therefore appreciate if you gave us aguideline on how we are supposed to carry out
our registration, the amount of money to be paid as the registration fee, and provide acopy of
fixtures for the matches set and give us description of terms of rewarding or reprimands if any.
We kindly request you to reply this letter as soon as possible. We are interested in doing
business with you. Thank you in advance.
Yours sincerely
tabby
Dalton Alpa
School principal
                                       Reply letter
                                                        Kabumbu football league management,
                                   1
                                   0
                                                                                  P.O BOX 2220
Nairobi.
Kenya.
Nairobi.
Kenya.
With great gratitude, we hereby reply your inquiry. Our organization deals with helping
various schools come up with a common way of arranging for league competitions which in
turn nurture the student’s talents and provide a basis for evaluation of every school’s
performance.
The registration is done online through the e-mail address, Kabumbu @Gmail. Co.ke or you
may call through 0726547206.The registration fee is ksh 50,000 per year. Atotal of 18 players
are required and a coach .A copy of the fixtures will be sent to you. Rewards to the best three
teams will be issued. Other details concerning the organization and how it runs will be issued
to you on registration.
For more inquiries please contact us again. We look forward to working and partnering with
you.
Yours sincerely
Tabby Wangari
Managing director
Advantages
                                   1
                                       1
 i.       Some concepts that were too difficult for the non-technical staff to explain could be
          observed and deductions made.
 ii.      It helped us get acquainted to the operational personnel through interaction. This also
          paved way for the staff to get used to the analysts so that when time comes for the
          implementation of the new system, the staff would not act cold.
iii.      It helped us to acquire the ‘know how’ needed to assist in changes that have been
          recommended.
iv.       It helped us to correct some of the misunderstandings that were made probably, in
          distorted information about the company.
Disadvantages
                                       1
                                   2
                                       Questionnaires
This is a very special purpose document that allows a person to collect information and
opinions from the people who receive and respond it. The following questionnaire was
prepared for the employees of the Kabumbu football league organization:
[ ] Computerized [ ] Manual
 Have you faced any challenges while working with the system above?
[ ] Yes [ ] No
[ ] Yes [ ] No
[ ]Yes [ ]No
 If yes state some of the changes you would like to be done on the system.
                                   1
                                     3
   Interview with the organization’s finance manager.
Time: 9.00 am
Q: How do you manage the organization’s data? Data like the member’s details and how do
you input it?
A: We input data manually by use of pen and paper and later file them. We have different files
for the different data. We have files concerning the members, the teams, employees, fixtures
and details of their registration.
Q: Does this input method or data storage method have its disadvantages or problems?
A: It has lots of disadvantages. First the data may not be well presented hence may appear
untidy. Secondly we incur lots of loss because inaccurate data may be entered in the financial
file, thus accounting for the lost money is a great problem.
A: If we had an efficient computerized way of storing of information then I think that most of
our problems would be solved.
Q: Indeed it would. Thank you so much for your time. Iwill send you a copy of the interview if
you don’t mind.
                                     1
                                  4
                               SYSTEM DESIGN
The current system was thoroughly studied and all shortcomings were identified. The analyst
now needs to get down to designing so as to create a system that would erase all the
problems faced currently. It will need to be compatible with the organizations operations and
be of benefit to every member of the staff or the employee and to the clients too.
The new computerized system should meet the user’s requirements in the terms of:
      Output
      Processing
      File/system security
      Input process
      User interface
Technology being dynamic , it expands day after day and that is why the new system won’t be
termed as extra perfect since better solutions keep on coming.
This new system will curb the problems encountered during analysis and the objectives
rendered during analysis together with others like making:
                                  1
                                   5
     A system to produce neat, tidy and presentable output.
     System that saves on space occupied.
SYSTEM FLOWCHARTS
These include graphical representations of a system that would portray an overview of the
new system being designed and created It includes the undertakings of the system , the
system’s ability to manage the data (the process it takes by either sorting or upgrading) and
the type of media used e.g. floppy disks, DVD’s or VCD’s, flash disks and many more . For more
illustrations KFL organization, diagrams are used t. These are:
 Structured charts
School’s details
Team’s details
Referees’ details             Calculate registration fees and
                              balance                              Reports on money paid
                              Determine games won and lost         Reports of winning and
                              Calculate money to be awarded        reprimanded teams
                              to the winning teams                 Reports of awarded teams
                                   1
                            6
Fig.05
18 Players
Awards
Fig.06
                            1
                                  7
Detailed design
Having the general functioning of the computerized system of Kabumbu football league
management system complete, it’s possible to come up with the details of the organization’s
management systems. These include;
      Output design
      Input design
      Files and data storage design
      Hardware and software requirements.
    Output Design
The output design incorporates what the user will see on the screen when running the system
and what will be printed out if there is any need for the hard copy.
This includes:
Reports
These are the most visible type of output in the working system.The section focuses on some
of the reports expected from the KFL management information system.
Below are some of the reports that can be outputted by the Kabumbu Football League
Management system.
                                  1
                                  8
 Registration reports
 Match results
Fig.08
 Fixtures
                               FIXTURES REPORTS
  DATE OF VISITOR                 VISITOR     VS           HOME           HOME
  MATCH          TEAM             SCORE                    SCORE          TEAM
Fig.09
 Input design
                                  1
                                     9
 For a high standard quality of output one has to ensure the input system must be of high
 quality too. Entry forms that are well designed and organized are therefore a requirement.
 They should be easy to use and effective. Some of these forms are:
School Name
Registration Fee
                                                                    d
       Delete Record           Previous Record               R ecor                se
                                                     Ne   xt                    Clo m
                                                                                    r
 Fig.10                                                                           Fo
                                      TEAM FORM
  ID
Players
Description
Penalty
                                                                             Close form
Delete Record                        2
                            Previous Record          Next Record
                        0
Fig.11
School Name
Penalty
                                  Previous   Next
                                  Record     Record
P
W                                Delete
                                 Record
D
                                             Close form
Mismatch home
Mismatch visitor
Goals for
Goals against
Pts
                        2
                                    1
   
     Fig.12
    Files and data storage design
Design of files and data store is another important aspect in detailed design. This is where
information for the system is held. The method used to store information in the Kabumbu
football league management system is relational files.
                                FIXTURES TABLES
FIELD                                            DATA TYPE
Date of match                                    Date/Time
Visitor team                                     Text
Visitor score                                    Number
VS                                               Text
Home score                                       Number
Home team                                        Text
Fig.13
                                    2
                                    2
Fig.15
Entity relationships
                                        League
                                        teams
 Registration
 of schools
Fixtures
Fig.16
After a detailed study of the new proposed system, the Kabumbu Football League
management decided to settle for the new system. This consequently meant that the
development team would start looking for all the hardware and software requirements that
the organization would now have so as to accommodate the new system hardware and
software specialists had to visit relevant stores in town so as to get the prices for the various
items. The table below shows an example of the hardware requirements of the organization.
Hardware requirement
                                    2
                                   3
         Hardware facility           Example                  Estimated cost
Fig.17
Below is a summary of the software requirements for kabumbu football league management
organization;
Software requirements
    Software                         Example                               Initial cost
1   GUI based Operating system       MS-Windows XP, vista, 2007, 2003, Ksh. 5000
                                     2010.
Fig.18
Data integrity constraints
                                   2
                                    4
These are rules that govern entering, changing and deletion of data and records in a database.
There are several types of integrity constraints. Some of them are;
 Domain integrity
 Referential integrity
 Entity integrity
These rules govern the composition of the primary key. A primary key cannot contain a null
value and must also be unique. Null values refer to empty spaces in a field that have no Value
or text.
 Referential integrity
This governs how the nature in a one-to-many relationship between tables in a database. All
foreign keys in the child table must have a matching record in the parent table.
 Domainintegrity
The term domain has been used to refer to the acceptable range of the values an attribute can
have. This ensures that no field takes on a value outside the range of valid values
Most information in computers is faced with the threat of unauthorized access. Microsoft
access database management software provides security for the data in the computer. These
include;
 Password protection
 Data encryption
                                    2
                                    5
To set up any of these security options, click the tools menu, point to the security and then
select the type of security you want to set up.
Password protection
This is the simplest security set-up that can be implemented using any Microsoft Windows
operating system. A password to open or edit the database file is set by the user who wishes
to use the system. This password to open is then made available to the authorized users only.
This lets the administrator assign permission to the users on database objects. The permission
includes opening, running the project and modifying.
This feature is used to assign permission to the users in order to limit user access to certain
database objects.
Data encryption
If the database is to be used in a network or sent electronically, encryption key to the data
from unauthorized access. Only the intended recipient can use the decryption key to read the
message.
CREATION OF BACKUPS
These are copies of the original document stored in different places of the computer or in
secondary storage devices for the need of security of the data system. They provide a chance
for the continuity of the system in case of damage or theft of one copy.
For the secondary storage flash disks and compact disks are recommended.
    In he dialogue box that appears, change the saving location to any other device or
     location you would prefer.
                                    2
                                   6
                             USER MANUAL
INTRODUCTION
Kabumbu Football League Information system is a computerized system that enables the users
to manage the data and information concerning various teams for many schools easily and
effectively.
With this one can input, process and finally come up with the required details and information
for the functioning of the organization.
One can also do most of the tedious work done manually to produce accurate and timely
results.
For one to load the system the following steps have to be followed:
   1) Once your computer is on, click the start button on the desktop, and then point to
      Microsoft access button. From the dropdown menu that appears click on the KABUMBU
      FOOTBALL LEAGUE SYSTEM.
   2) A log on dialogue box will be displayed. Enter the password for the system and click OK.
      The system‘s password is WANGARI97. Care should be taken so as to write the
      password for the right case i.e. UPPERCASE.
Fig.19
                                   2
                                   7
   3) The system main form will appear from where one can access all other forms, tables
      and reports
Fig.20
Menu description
Within the Main form there are buttons that help the user to choose the form or report they
want to view. These buttons are;
 REPORTS button
From the main form, press the data entry button to access all the forms that are available for
data entry in the system. Below is the dialogue box that appears for the data entry form;
                                   2
                                    8
Fig.21
Clicking this button enables one to enter or view data on the registration of the schools.
Fig.22
                                    2
                                   9
League Table Sub-folder
Clicking on this button enables one to view information concerning each team’s details; the
number of games they have played, goals they won/lost, penalties, etc.
Fig.23
Team Form
This form contains details of the players and their positions, coaches and referees in each
team.
Fig.24
                                   3
                                   0
Close Form
 REPORTS BUTTON
The reports button enables the user to access all reports that are in the system. The reports
display the information already processed and is displayed to the user. Below is an interactive
screen that appears when you click the reports button.
Fig.25
Fixtures Report
This report contains match results between any two teams and states whether they are
home/visitor matches to the team.
Fig.26
                                   3
                                    1
League
Fig.27
Match Results
This report displays the match results for all the teams with description, whether it’s
home/visitor match.
                                    3
                                    2
Fig.28
Players
Displays the school code, the players name, his description and the number of penalties.
Fig.29
Penalties
                                    3
                                    3
Fig.30
School Registration
Fig.31
Close form
                                    3
                                    4
Error message- the changes you requested the form were not successfully able because they
would create duplicate values in the index, primary key or relationship.
Error message- Fields with a primary key cannot contain a null value.
Description-you are trying to proceed to another record or field yet you have not selected the
field name of the record in focus.
Solution- Select the field name before you proceed to the next record.
Error message-the value that you entered is not valid for this field.
                                    3
                                     5
Description- You are trying to enter an invalid data in the field.
                        IMPLEMENTATIO
This is the last
                              N                                                         step
of the development of the system. It involves putting the new system into use in the company.
The tasks during implementation are:
    Staff training- This involves teaching the staff members about how the new system
     works. This is done without interfering with the business operations.
 Security control measures are taken in case the new system breaks down.
    Changing over from the old manual system to the new computerized system using the
     most appropriate method.
After the installation of the new system, the users are supposed to ensure that it is properly
running. This is to be done using a follow up evaluation.
                                     3
                                   6
                       MAINTENAN
System maintenance is the adjustment and the enhancement of the requirements or
correction of errors after the system has been implemented. These errors may be detected
when the system is in use. Maintenance of a system is important because:
The diskettes that contain the original system should not be used to run the program; rather
one should make copies to ensure that the original system remains intact with minimal chance
of being interfered with. The diskettes should be stored safely from dust, liquids and in a cool
dry place to prevent data loss.
They act as data reference materials if need for changes should arise in the near future.
                                   3
                                   7
                                 CONCLUSION
Developing this project has been a great challenge posed to me but all in all I am glad to have
managed to complete it. It’s been frankly a journey of 4 months to make the Kabumbu
Football League Management System a success. I greatly hope that this system will serve its
purpose efficiently. However, being human and prone to mistakes I willingly accept any
criticism that may arise due to any unnoticeable mistakes and will definitely do my best to
rectify them in future. Accept my sincere apologies for any defects in advance.
Despite the many obstacles throughout the process, it has helped me upgrade my knowledge
on how an efficient and effective system should be created with the advancing technology.
Can’t forget to note that it helped me better my typing skills and creativity.
                                   3
                                   8
       RECOMMMENDATION
I recommend that this project should be adapted especially by the Football organization’s
around so as to enhance their quality.
                                   3
                                  9
BIBILIOGRAPHY
This shows the list of books and reference materials used in developing Kabumbu football club
system.
                                  4
                                      0
APPENDICES
Interview: a dialogue where one asks people of their opinions about a subject
                                      4
                                   1
Module: a unit of computer system or program that has a particular function