ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

List of figure
Figure 1:diagram of rapid application development(RAD) .......................................................... 14
Figure 2:Gantt chart ...................................................................................................................... 17
Figure 3: ER diagram .................................................................................................................... 23
Figure 4:Physical database for police officer................................................................................ 24
Figure 5:Physical data base for library officer .............................................................................. 24
Figure 6:Physical database design for proctor officer .................................................................. 25
Figure 7:Physical data based design for café officer .................................................................... 25
Figure 8:use case diagram ............................................................................................................. 26
Figure 9:Sequence Diagram-Login ............................................................................................... 31
Figure 11:class diagram for a system............................................................................................ 33
Figure 12:home page for a system ................................................................................................ 34
Figure 13:background and mission for jit ..................................................................................... 35
Figure 14:login form ..................................................................................................................... 36
Figure 15:manger home page........................................................................................................ 37
Figure 16:to create account for user.............................................................................................. 38
Figure 17:to view student information .......................................................................................... 38
Figure 18:library home page ......................................................................................................... 39
Figure 19:to check student id number ........................................................................................... 39
Figure 20:valid id number ............................................................................................................. 40
Figure 21:registration form for crime student in library ............................................................... 40
Figure 22:student information in library ....................................................................................... 41
Figure 23:home page for police home page .................................................................................. 42
Figure 24:home page for proctor .................................................................................................. 42
Figure 25:home page for student .................................................................................................. 43
Figure 26:request page for student ................................................................................................ 43
Figure 27:clearance slip for students ............................................................................................ 44

i
 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

List of table
Table 1:Gantt chart ....................................................................................................................... 16

ii
 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

chapter one
1.1 introduction and background
Nowadays, internet services become very much popular and there is extremely increase of
internet in all over the world for education purpose. Its ‘Multidimensional benefits are
becoming more observable from time to times. Additionally, it helps to increase the qualities of
the work, reduces the complexities of tasks, keeps the security of data in most advantageous
condition, makes data transfer more easy, and others.
JIMMA University (JIMMA institute of technology) currently used manual process of signing
the clearance. This process causes queuing in a very long line of students waiting for their
clearance to be sign by the assign faculty staff. The students’ needs to fill up the clearance form
given by their class adviser then go to the respective faculty staff that needs to be sign in the
space provided where they will write their signature. So the proponents got an idea to transform
the traditional manual process of signing the student clearance into online based so that in
couldn’t cause problems to the students, faculty staff and also with the university itself so that
the university can provide a quality service to all of the students in the university.
In relation with this study is the pressing problem after semester break and summer vacation
ends. It is the signing of clearance. Students need to comply with their requirements as a
prerequisite of the signing of clearance. If they are not able to take their clearance in completion,
they are not able to enroll for the next school year. But the problem is they need to fall in a long
line to have a sign to different people who are in the position and take a long period of time
waiting to complete it. Why don’t the process of clearance be easier and not a troublesome?
Technology can make it convenient to the student.
In manual system the student will just fill up the clearance form and sends it to the first faculty
staff when the faculty staff are done putting the signature which is stored in the system that
faculty staff should now send the clearance form of the student to the next signer of clearance
then the process will just repeat until it reaches the last signer. After putting the signature, the
last signer will now send back the finish clearance to the student.
The proposed system online student clearance system is an internet-based application that is
designed for the students that would like their clearance signed with convenience and less hassles
and for the faculty staffs that would like to sign witch just some clicks of the mouse. The Online

School of electrical and computer Enginerring June 20, 2016 1

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

Clearance Signing we will be developing is similar to the manual clearance signing process. The
difference here is that our proposed system will be adopting the traditional clearance signing to
make it online. It is a user friendly application that could be used by all the students and faculties
involve in the traditional signing of clearance. Compared to the existing system that the system is
using our proposed online clearance signing system is much more efficient to use. Since it is an
online based application it will do the work just like in the existing system that we use where the
students time to time go to the designated faculties.

1.2 paradigm of the study

Input Process
Problem countered in Output
Observation
clearance system Online student
Interview
Software requirement clearance system
RAD (agile meth
For jit
specification (SRS) ology)

Explanation for the above diagram

Input phase: problem countered in manual system is student carry out his/her clearance form
it go to different office, the officer checks the students then if it is free signature on that paper.
SRS:it minimizes the time and effort required by developers to achieve desired goals and also
minimizes the development cost. A good SRS defines how an application will interact with
system hardware, other programs and human users in a wide variety of real-world situations.
Parameters such as operating speed, response time, availability, portability, maintainability,
footprint, security and speed of recovery from adverse events are evaluated.
Process; conduct our project enables us to list out the existing system problems, since it is
what we see or observe in reality.
Observation: it a method to gather an important information relevant to the system
RAD;Rapid application development (RAD) is a suite of software development methodology
techniques used to expedite software application development.
RAD uses predefined prototyping techniques and tools to produce software applications. It

School of electrical and computer Enginerring June 20, 2016 2

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

encompasses a graphical user interface (GUI) development environment, allowing end users to
easily drag and drop required software application components.
Output; the output for a given system is that an implemented and efficient web based online
clearance system

1.3 statement of the problem

Student clearance system is one of the task that is performed manually in Jimma University.
These tasks are done in the old conventional method i.e. manually but, this method have a
serious of problem in performing the activities. Some of the problems are:
 consumption of resource (i.e. wastage of time, labor force, cost)
 Lack of good service for the students
 Inaccurate statistical data gathered from time to time due to its dependent on the time in
which it's ordered
 very tiring documentation which is manual system
 Students' data is not correctly or properly stored, because they perform according to the
predetermined file format.
Furthermore, for all student to carry out his/her clearance from all these departments it normally
takes a lot of time and a lot of processes and delay in clearing the student for youth service as
well as collection of statement of results. Hence, it became imperative for computer software
based online clearance system to eliminate the shortcoming of the manual system in place.

1.4 objectives of the study

The main objective of this project is to design and implement online clearance system for Jimma
University.
The specific objective of this project is mentioned below;
 To assess the current clearance system done by Jimma University;
 To understand the problems encountered by the stakeholders
 To formulate the SRS of the proposed system
 To understand design considerations of the proposed system
 To test the acceptability of the system

School of electrical and computer Enginerring June 20, 2016 3

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

1.5 significance of the project

The project work will help in a good number of ways to ease the queuing system in the
university as the online clearance system will help student to achieve whatever they want to
achieve without coming to the various offices for clearance.
Clear advantages of internet information processing over those of traditional manual system are
higher yields. Online clearance system allows the users to check their clearance status as whether
they are in any way indebted to the school, fill and submit their clearance form, and obtain their
clearance letter. There are many other advantages of online clearance system and some of them
are listed below
 It saves a lot of time.
 Information processing is very fast and delays can be avoided.
 It is inexpensive to student and school management.
 It is also help the school in reducing cost such as labor and stationary.

1.6 Scope of the project

This project work is to develop a web based online clearance system for doing clearance for
students of JIMMA University. This was done to attain a standard output that will be useful to
both students and as well as the staff of university. It also helps in making a quick, accurate,
efficient and reliable data processing.

1.7 Limitation of the project

This project covers some of the aspect of a computer software based online clearance system
using Jimma University as case study.
However, the following are the constraints:
1. Time constraints; Due to time constrain the web-page covers only clearance for various
staff office by the all year student.
2. Financial constraints; Due financial constraints it cannot afford this kind of process
online especially towards the cost of accessing the internet. Therefore, it would cost a lot
to develop a full web-based clearance system.

School of electrical and computer Enginerring June 20, 2016 4

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

1.8 definition of terms

Computer Network; Computer network is a system that connects two or more computers
together using a communication link.
World Wide Web: World Wide Web simply called” www” is the most important tool of the
internet, it was created in the late 1980’s in Europe and was limited.
Clearances: official certification of blamelessness trust worthiness or suitability for graduation
and issue of certificate in degree course.
File Transfer: Any kind of computer file can be sent via the internet from one internet user to
another. Table of account in a spreadsheet, design by a graphic artist, music and sound files etc.
can all be exchanged in this way.
Web Browser: this is special kind of software that processes hypertext mark-up language
(HTML) document. In other words, a web browser is a computer program that interprets HTML
command to collect, arranged and display the parts of a web page.
Web Site: A web site is a collection of many interconnected webpages organized by a specific
college, organization company etc., containing web page (goods and commodities) on the
internet. Web site is stored on web servers. There are many web sites and thousands of HTML
pages on each web site. A web is a treasure of information and entertainment.
Hyperlinks: Hyperlinks are highlighted words and phrase you find on a web document that you
can click on as to jump to some other document or internet services.
Online: connected via a computer attached to or available via a central computer network
Offline: Disconnected from computer network, describe a computer terminal or peripheral
devices disconnected from a computer network.
System: Set of computer components that is, an assembling of hardware, software and peripheral
functioning together.

School of electrical and computer Enginerring June 20, 2016 5

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

Chapter two
2.1 Literature review
2.1.1 role of information technology in the academic system
The essence of this review is to make known of some other research made in relevance to the
project topic. Many researchers have made some findings on how this problem can be solved
and achieve the objective of the subject. As many tertiary institutions as have chosen to pursue
the dynamic educational options available online, the advantages of e-learning are now many.
As people of this generation become more dependent on the internet for information, the need
for an online clearance system becomes more apparent. The skills needed to access and
comprehend information online are becoming commonplace, and the flexibility of wireless
computing means that any coffee shop, airport or bedroom can become a classroom. Online
courses, registrations, clearance have few, if any scheduling restrictions, well integrated learning
resources and competitive degree options, with an online clearance system. Online system has
become a central element of the discourse on higher education. There seems to be an overall
derive towards online system given the mountain need for flexibility in scheduling and the daily
emergency of communication technology and capabilities.
Online system is presented as a means of conveying instruction to an extensive learning
community any place at any time. Indicate that adequate designate online learning as the driving
force and model for transformation in teaching, learning and formal schooling online course has
the potential to provide learner individualized attention by the instructor, otherwise impossible in
a large classroom environment (environmental education and training partnership 2006). With
the continued development of online system applications, many colleges and Universities have
begun to offer online courses as an alternative to traditional face-to-face instructions. 67% of
colleges and universities agreed that online education is the most logical long term strategies for
their institutions. However, there are considerable hesitation rising predominantly related quality
and student respectively to online system. Just as their advantages there are also disadvantages to
the online system instruction delivery method. There is evidence through previous research that
student fill isolated or disconnected when not engaged in traditional face-to-face instruction,
while other report indicate large success. There remains a lack of clarity whether online courses
are as affective as traditional courses. While there has been vast amount of research conducted
on the advantages and the disadvantages of online system institution, little is known on how

School of electrical and computer Enginerring June 20, 2016 6

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

assessment is used in online classroom to monitor performance and progress and describe the
evaluation of current online education system at three levels; the macro level, the meso level and
micro level. The macro level is an online evaluation that access an entire online program, the
meso level evaluation access individual online courses, and the micro level access the learning
of the online student.
Online clearance system presents educational experience very different from standard face-to-
face environment. When conducting a micro level courses evaluation, interest commonly lies in
learner perception of the course experience pertaining to the level of comfort, ability to
communicate with class mate and the instructor, as well as comparison to traditional face-to-face
lecture. Many times the only means of evaluating learner perception is in the form of a
questionnaire or survey. Although perception of online system can be extremely useful
information, it is usually not sufficient to conclude the evaluation without expanding to learners
understanding.
The concept of the proposed system was derived from the old slow manual transaction of
clearance in JIMMA institute of technology campus. Slow manual transactions cause delay in
clearance reports and enrolment. Online clearance signing can be used through the use of
personal computers (PC’s), laptops or any device that can connect to the internet. It is a
transaction that uses the internet for securing the clearance of a student. It contains the
application form for clearance and a student registration to use the system. Using the proposed
system instead of the traditional system that requires students to go to the faculty’s offices, fall
in line and wait for their clearance to be signed. Then the same process will be repeated until all
the required transactions are completed.

2.1.2 data and information

The concept of data and information are very important in understanding issues that go with
development and implementation of a computer software based online clearance system. The
term “data” and “information” are used interchangeably every day conversation as meaning the
same thing. Too many manager and information specialist. However, these terms have distinct
meaning. According to O’Leary (1996) data simply consist of raw unprocessed facts while
information is a data that have been processed by the computer. Horde ski (1986) gives the
following definition of data; A graphic or textual representation of facts concepts, numbers,

School of electrical and computer Enginerring June 20, 2016 7

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

letters, symbols or instructions suitable for communication, interpretation or processing. Data is

the basic element of information that is use to described objects, ideas, conditions or situations.
Lucy (1991) defines data and information as Data is fact events, transactions and so on, which
have been recorded. They are the raw materials from which information is produced.
Information is data that has been produced in such a way as to be useful to the recipient. Data
are fact obtained by observation, counting, measuring, weighing etc., which are often records of
day-to-day transactions of the organization. For example, the date, amount, and other details of
an invoice or cheque, payroll details of payment, the number of a student living in a particular
hostel and so on. Enwerem (1992) argue that concept of information in an organization sense is
more complex and difficult than the frequent use of this common word would suggest. Oketunji
(2002) emphasized that information is data that have been processed, transmitted by the
recipient, interpreted and understood by the recipient. Here it should be noted that the user, not
just the sender is involved in the transformation of data into information. There is a process of
though and understanding involved and if follows that a given message can have different
meaning to different people. Based on this, one can conclude that data which has been analyzed,
summarized or processed in some other fashion to produce a message or report which is
conveniently deemed “management information” only becomes information if it is understood
by the recipient. Therefore, it the user who determine whether a report contains information or
just processed data [3].

2.1.3 technology enhance computer software based online

clearance system
According to Jeremy v Ernest, a comparison of traditional and hybrid online system in
communication technology. Online system has become a central element of the discourse on
higher education (cox 2005). There seems to be an overall derive towards online system given
the mountain need for flexibility in scheduling and the daily emergency of communication
technology and capabilities (Hill stock 2005).

Online system is presented as a means of conveying instruction to an extensive learning

community any place at any time Cox (2005). Indicate that adequate designate online learning as
the driving force and model for transformation in teaching, learning and formal schooling online

School of electrical and computer Enginerring June 20, 2016 8

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

course has the potential to provide learner individualized attention by the instructor, otherwise
impossible in a large classroom environment (environmental education and training partnership
2006).
With the continued development of online system applications, many colleges and universities
has begun to offer online courses as an alternative to traditional face-to-face instructions. 67% of
colleges and universities agreed that online education is the most logical long term strategies for
their institutions (Hill stock 2005). However, there are considerable hesitation rising
predominantly related quality and student respectively to online system, (Yong and Connells
2004). Just as their advantages there are also disadvantages to the online system instruction
delivery method. There is evidence through previous research that student fill isolated or
disconnected when not engaged in traditional face-to-face instruction (Guho 2001, Graham
2001), while other report indicate large success (Hoff man 2002, Kaczynski and Kelly 2004:
Mayer 2002). There remains a lack of clarity whether online courses are as affective as
traditional courses (Poirier and Feldman 2004).
While there has been vast amount of research conducted on the advantages and the
disadvantages of online system institution, little is known on how assessment is used in online
classroom to monitor performance and progress (Liang and Jeremy v Ernest Jeremy_ernest @
[Link]) is an assistant professor in the department of mathematics science and technology
education at North Carolina state university Ralugh. Journal of technology education volume 19
No.2 spring 2008 (Creasy 2004). Hew, Liu, Martinez. Bonk, and Lee (2004) describe the
evaluation of current online education system at three levels; the macro level, the meso level and
micro level. The macro level is an online evaluation that access an entire online program, the
meso level evaluation access individual online courses, and the micro level access the learning
of the online student. Online clearance system present educational experience very different
from standard face-to-face environment (Hew, Liu, Martinez, Bonk and Lee 2004). When
conducting a micro level courses evaluation, interest commonly lies in learner perception of the
course experience pertaining to the level of comfort, ability to communicate with class mate and
the instructor, as well as comparison to traditional face-to-face lecture. Many times the only
means of evaluating learner perception is in the form of a questionnaire or survey. Although
perception of online system can be extremely useful information, it is usually not sufficient to
conclude the evaluation without expanding to learners understanding.

School of electrical and computer Enginerring June 20, 2016 9

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

2.1.4 computer-based online information system

An information specialist Lucey (1991) define computer based management information system
as: the combination of human and computer based resource that result in the collection, storage,
retrieval, communication and use of data for the purpose of efficient management of operations
and for business planning.
Computer based information system is a feature of all large organization nowadays. The
literature identifies four kinds of computer based information: Transaction processing system
(TPS), management information system (MIS), decision support system (DSS) and executive
support system (ESS). Some system record routine activities: Employees hired, material
purchased or produced and the like. Such recorded events are called transactions. Other system
uses this recorded event to help managerial planning and control. The systems form a pyramid
each primarily supporting one another level of management.

a. Transaction processing system (TPS): these system record day-to-day transactions such as
customer order, bills, inventory levels and production output. The TPS helps supervisors by
generating data base that act as foundation for other information system.
a. Management information system (MIS). These summarize the detailed data of the transaction
processing system standard report for middle level managers. Such report might include
production schedules and budget summarizes.
B. decision support system (DSS); The DSS provide the flexible tools for analyzes. The DSS
help middle level managers and other in the organization analyze a wide range of problem, such
as effect of event and trend outside the organization. Like the MIS, the DSS draws on the
detailed data of transaction processing system.
C. executive support system (ESS): The ESS is easy-to-use systems that present information in a
very highly summarized form. It helps top level management to oversee the company operation
and develop strategic plans. The ESS combines internal data from TPS and MIS with external
data.

School of electrical and computer Enginerring June 20, 2016 10

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

2.1.5 data bases

In the early days of computerization, it was normal to maintain specific files for individual
application. Data where processes centrally in batches and there was little or no online
interrogation of data. This approach is wholly inefficient for most of today’s data processing
systems. Supporting this vossen (1991) enumerated the problems that result from organizing the
data using the file system.

a. There exists a high redundancy between files which result from the fact that the information is
replicated in different places, and that these replications are not controlled by a central monitor
b. Inconsistencies might result from the possibilities that a program makes changes on the files it
uses without these changes being made (at the same time) by all other programs that uses the
files.
c. There exist in flexibility against changes in the application: if new actions or event arise in the
cause of time, these can be realizing at a substantial expense of time.
d. The work of many programmers involved is characterize by low productivity, seems program
maintenance is expensive: if the structure of an existing file has to be modify during it life time,
then all application program has to be modify correspondently
Finally, there is the problem of adopting and maintaining standard (with respect to coding data
format etc.), which is important for exchanging data or for migration to new operating system
released, or even to a new computer system.
To overcome these problems, data bases where developed. It is now common for large
organization to organize their operational data using the data base technology.
The subject of data is adequately covered in many works in data base technology. Clifton
(1983) briefly define data base as a collection of data supporting the operation of an
organization. Quoting CIMA, Lucey (1991) provide a more detailed definition. A data base is
a file of data structured in such a way that it may serve a number of application without it
structure being dictated by any one of those application, the concept being that programs are
written round the data base rather than files being structure to meet the need of particular
programs.
Russel M. (1987) dealt extensively on the need for the use of computer on such data base
system like computerized clearance system. In the world of Dimorji (2003). “At the center of

School of electrical and computer Enginerring June 20, 2016 11

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

any information system is a data base, which is any collection of related information grouped
together as a simple item. The term can also apply to the ways in which information is
catalogued, analyzed, stored and used manually”. Rossell (2005) was also of the view that
without computer, effective handling of candidate record cannot be achieved effectively in a
data base, all the data is defined together rather than each file being define separately. In fact, all
the literature consulted seem to support the fact that a data base is a collection of structured data
with the structure of data being independent of any particular application. Specify the need for
data base, O’leary (1996) listed the following advantages:
a. Sharing: in an organization, information from one department can be readily shared with
others.
b. Security: users are giving password or access only to the kind information they need to
know. Thus, the payroll department may have access to employees pay rate but they
would not.
c. Fewer files: with several departments having access to one files, there are fewer files
therefore, excess storage or what is called redundancy is reduced.
d. Data Integrity: older filing system many times did not have integrity i.e. a change made
in the file in one department might not be made in the file in another department. As one
might expect, these can cause serious problems and conflict when data is used for
important decision affecting but department.
To advantages enumerated above, vossen (1991) at abbs.
a. Standard/access protocols can be enforced.

b. Currency of data can be maintained.

c. Data/program independent can be maintained.

d. Conflicting requirement can be balanced among users.

In these days of integrated networks, the database appeared as the most logical method for
organizing the operational data of large organizations. One may as well say that these
advantages give the database the attraction over the traditional file processing method.

School of electrical and computer Enginerring June 20, 2016 12

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

Chapter Three
3.1 Methodology
Methodology is a formalized approach to implement the SDLC (System Development Life
Cycle). There are many different systems development methodologies, and each one is unique
based on the order and focus it places on each SDLC phase. So we selected RAD with Agile
Methodology.

Rapid Application Development (Agile Approach)

RAD methods take iterative ideas to the extreme. Instead of using iterations lasting a year or two,
their iterations last a month, a week, or even less. Some RAD techniques also apply iteration to
everything, not just to programming. They apply iteration to requirement gathering, requirement
validation, and design. Aside from this the proponents consider the following advantages which
made them to conclude such methodology. This advantages are the following:
 More accurate requirements.
 The ability to track changing requirements.
 Frequent customer feedback and involvement.
 Reduced development time.
 Encourages code reuse.
 Possible early releases with limited functionality
 Constant testing promotes high‐quality code and eases integration issues.
 Risk mitigation.
 Greater chance of success.

The proponents will also be using Agile Development because Agile development is more a set
of guidelines than an actual development model. It includes a set of principles that its founders
believe can help with any development effort. Because it’s a set of guidelines, there are many
ways you can interpret its rules. For example, people often say a particular method is “an agile
technique” because it attempts to address one or more of the guidelines [8].

School of electrical and computer Enginerring June 20, 2016 13

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

Figure 1:diagram of rapid application development(RAD)

 Requirements planning phase – combines elements of the system planning and

systems analysis phases of the Systems Development Life Cycle (SDLC). Users,
managers, and IT staff members discuss and agree on business needs, project scope,
constraints, and system requirements. It ends when the team agrees on the key issues
and obtains management authorization to continue.
 User design phase – during this phase, users interact with systems analysts and
develop models and prototypes that represent all system processes, inputs, and outputs.
The RAD groups or subgroups typically use a combination of Joint Application
Development (JAD) techniques and CASE tools to translate user needs into working
models. User Design is a continuous interactive process that allows users to
understand, modify, and eventually approve a working model of the system that meets
their needs.
 Construction phase– focuses on program and application development task similar to
the SDLC. In RAD, however, users continue to participate and can still suggest
changes or improvements as actual screens or reports are developed. Its tasks are
programming and application development, coding, unit-integration and system
testing.
 Cutover phase – resembles the final tasks in the SDLC implementation phase,
including data conversion, testing, changeover to the new system, and user training.
Compared with traditional methods, the entire process is compressed. As a result, the
new system is built, delivered, and placed in operation much sooner.

School of electrical and computer Enginerring June 20, 2016 14

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

3.2 method of data collection

During this project research work, data needed for the project was gathered from the various
sources. In gathering and collecting necessary data and information needed from the system
analyses, two major fact-finding techniques were used in this work and there are:

a. Primary Source:
This refers to the source of collecting original data in which the researcher made use of empirical
approach such as personal interview and questionnaires. This are some method to get primary
source;

Questioner
We would conducted questioners for the Online Student clearance system to study the
existing system and develop the new system.
Interview
we would gathered information by interviewing the Registrar officers about the existing
student clearance system. The questions we have prepared were open ended questions. We
choose this type because we can get detailed information about the current system and also not to
limit the available responses for the question.
Observation
enables us to list out the existing system problems, since it is what we see or observe in reality.

b. Secondary Source
The secondary data were obtained by the researcher from magazine, journal, newspaper,
library source and internet downloads. The data collected from this means have been
covered in literature review in the chapter two.

School of electrical and computer Enginerring June 20, 2016 15

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

3.3 Tools for data analysis

Use Case Diagram: To model a system the most important aspect is to capture the dynamic
behavior. To clarify a bit in details, dynamic behavior means the behavior of the system when it
is running /operating.

Sequence Diagram: is an interaction diagram that shows how objects operate with one another
and in what order. A sequence diagram shows, as parallel vertical lines (lifelines), different
processes or objects that live simultaneously, and, as horizontal arrows, the messages exchanged
between them, in the order in which they occur. This allows the specification of simple runtime
scenarios in a graphical manner.

Class Diagram: is a type of static structure diagram that describes the structure of a system by
showing the system's classes, their attributes, operations (or methods), and the relationships
among objects.

ER Diagram: describes inter-related things of interest in a specific domain of knowledge. An

ER model is composed of entity types (which classify the things of interest) and specifies
relationships that can exist between instances of those entity types.

Database Instance: A database instance is a set of memory structures that manage database
files. A database is a set of physical files on disk created by the CREATE DATABASE
statement. The instance manages its associated data and serves the users of the database.

3.4-Time schedule of the project

For the time scheduling purpose, the Gantt chart is being used in order to show a simple
indication for the project’s progress in each and every phase.
Table 1:Gantt chart

Task start day days to complete

Requirements planning phase 22/4/2016 8
User design phase 1/5/2016 12
Construction phase 13/5/2016 18
Cutover phase 6/6/2016 16

School of electrical and computer Enginerring June 20, 2016 16

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

11/3/2016 31/3/2016 20/4/2016 10/5/2016 30/5/2016 19/6/2016 9/7/2016

Requirements planning phase

User design phase

Construction phase

Cutover phase

Figure 2:Gantt chart

School of electrical and computer Enginerring June 20, 2016 17

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

Chapter four
4.1 System design and implementation
System design is the process and focuses on decomposing the system into manageable parts.
During requirements analysis, we concentrated on the purpose and the functionality of the
system. During system design, we focus on the processes, data structures, and software and
hardware components necessary to implement it. The challenge of system design is that many
conflicting criteria and constraints need to be met when decomposing the system. The analysis
model describes the system completely from the actors’ point of view and serves as the basis of
communication between the client and the developers. The analysis model, however, does not
contain information about the internal structure of the system, its hardware configuration, or,
more generally, how the system should be realized. System design results in the following
products:
 List of design goals, describing the qualities of the system that developers should
optimize.
 Webpage architecture, describing the subsystem decomposition in terms of subsystem
responsibilities, dependencies among subsystems, subsystem mapping to hardware,
and major policy decisions such as control flow, access control, and data storage.

4.2 general analysis of existing system

The current clearance system in Jimma university is a manual one. These make the system
tedious and time consuming. Here, student has to visit all the clearance offices with a form for
them to sign, once this forms are sign, it proves that the student has been cleared, the process
takes some months to be completed and processes a lot of stress to both staffs and the student
involved. In the manual system, the clearance forms are documented in a file cabinet. Each time
the clearance form is needed, a search operation is conducted on the file cabinet to
locate a particular student clearance form.

School of electrical and computer Enginerring June 20, 2016 18

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

4.2.1 problem of the current system

Due to the manual means been used by the university, keeping information about
student clearance, a lot problems are encountered which includes:
 Delay in processing clearance form
 Unavailability of some key staffs while processing clearance that leads student repeatedly
visiting a particular office in order to sign a clearance paper.
 Lose of vital document as the filing system is manual.
 Damage of document due to fire or rain incident.
 Illegal removal of forms by fraudulent staff leading to insecurity.
 Take a lot of time to retrieve a particular clearance form.

4.3 justification for the new system

The new system is designed to solve problem affecting the manual system in use.
It is design to be used online thereby relieving both student and staff from much stress as
experienced from the manual system. This will do the analyzing and storing of information either
automatically or interactively, it will make use of online access to internet.
The proposed system will also have some other features like.
 Accuracy in handling of data
 Fast rate of operation and excellent response time.
 Better storage and faster retrieval system
 Flexibility i.e. it can be access at any time
 Easy way of backup or duplicate data in diskette in case of data loss
4.4 Software requirement specification
The requirement needed to implement this system is as follows:
4.4.1 Hardware requirement
For the effective operation of the newly designed system, the following minimum
hardware specifications are recommended
 The computer system in use should be IBM compatible since they are
considered clone system
 The Random Access Memory (RAM) should be at least 128KB.

School of electrical and computer Enginerring June 20, 2016 19

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

 The system should have a hard disk of at least 50GB and at least a diskette
drive of high density of 1.44mb(3.5 inches)
 The system should be equipped with an E.G.A/V.G. A, a colored monitor
 An uninterruptible power supply (UPS) units
 It should internet ready

4.4.2 Software requirements

The software specification required on the computer system is. A window 8.1 or higher version
for faster processing

 Text editor (notepad++)

 Xampp version 5.4
 Google chrome web browser
 Microsoft viso 2013 for drawing
4.5 Class Type Architecture
The objectives of designing are to model a system with high quality. The ability of the
programmers to implement a high-quality, error-free system depends very much on the nature
of the design created by the designer; also, the ability of the maintenance programmers to make
changes to the system after it has been put into operation and to the expanded system depends
on the quality of the system design. The field of structured design contains a number of
guidelines that help designer determine which modules, and which interconnections between
the modules will best implement the requirements specified in the system analysis
The architecture chosen for the system is three tiers. The first tier run on the client side
(interface), the second tier at the middle tier (Business class) and the third will be the database
system (Access class). The system runs using web technology. This architecture provides
greater application scalability, high flexibility, high efficiency, lower maintenance, and
reusability of components. Since each tier run on different machines it will increase system
performance. The system uses dynamic web technology, i.e. adding and retrieving data to and
from when the data store when required. It also requires client side programming and interface
that communicates with the external system. It needs the server functions to implement
functional requirements and database system to store data.

School of electrical and computer Enginerring June 20, 2016 20

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

4.6 Business rule

 clearance is possible if and only if the ID of the student is valid for all student.
 There will be fine charge for those student who has not taken clearance slip on time
 Only clearance officer(manger) has modify student information

4.7 Functional Requirements

Functional requirements These are statements of services the system should provide, how the
system should react to particular inputs, and how the system should behave in particular
situations. It specifies the software functionality that the developers must build into the product
to enable users to accomplish their tasks.
 The system must have a dynamic website that provides successfully registration of users.

 The system should allow users to login to the system using their username and password.

 The system should provide to modify record that is deleting, editing and inserting as well
as retrieving the required information (for admin).

 The system should have well organized information storage and accessing mechanism.

4.8 Non-Functional Requirements

The non-functional requirement describes constrains for implementing the project. Some
Of them are; the central server have to be provided at secured area, the system must be
Maintainable and expandable. These requirements do not directly affect the performance of the
system but their presence is useful for the system. A non-functional requirement relates to the
technical aspects of system must fulfill, such as performance-related and reliability issues.

Some of the non-functional requirements are: -

Security: - The system must be protected from being accessed by unauthorized

students.

Availability: - The system should easily be available at any desired time.

Performance: - The system should be well fit to perform operations clearly without
any problem.

School of electrical and computer Enginerring June 20, 2016 21

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

4.9 Persistence Modeling (Data Base Modeling)

Among the various types database design models Relational database management system is
used so it needs to work on persistent modeling. Relational databases do not completely
support object-oriented concepts, so the design of the database is different from the design of
class diagram. Persistence models enable to design the schema of the database. It is divided
into three phases: conceptual, logical and physical modeling.
Conceptual – is the process of constructing a model of the information, independent of
physical considerations.
Logical – is the process of constructing a model of the information based on a specific data
model.
Physical – is the process of producing description of the database on the secondary storage.

School of electrical and computer Enginerring June 20, 2016 22

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

4.9.1 ER diagram

Sex Type

[Link] [Link] n

Crime
Department
name
[Link] crime ID

age 1
student Register for

1
name
Account
sex type
Stud ID
Address view
Recieve
Manager manages Account

1
manager ID n
clearance Address account ID

Clr ID
1

Figure 3: ER diagram

School of electrical and computer Enginerring June 20, 2016 23

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

4.9.2 Physical data base design (modeling) Class to table mapping

[Link] layer for police officer

Figure 4:Physical database for police officer

[Link] layer for library officer

Figure 5:Physical data base for library officer

School of electrical and computer Enginerring June 20, 2016 24

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

[Link] layer for proctor officer

Figure 6:Physical database design for proctor officer

[Link] layer for café officer

Figure 7:Physical data based design for café officer

School of electrical and computer Enginerring June 20, 2016 25

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

Use case diagram

To model a system, the most important aspect is to capture the dynamic behavior. To clarify a bit
in details, dynamic behavior means the behavior of the system when it is running /operating

Request
Register Crime Student

Student Librarian

search student info

Login

Police
Create Account
Manager

delete student info Proctor

Update account

Delete account View Student detail

Food Service

Figure 8:use case diagram

School of electrical and computer Enginerring June 20, 2016 26

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

Discerption of use case diagram

1. Use case name: request
Actor(s): student
Description: Allow student to request clearance slip online
Precondition: the user should have to be assigned to JJU and have University ID
Alternative course of action: If student enters invalid username and password then the
system display error message.
2. Use case name: Login
Actor(s): Student, manger, library officer, café officer, proctor officer, police officer
Description: allow student, all staffs to login the system
Precondition: the user can have a user name and password to login
Basic course of action
1. The system requests the actor to enter the correct username and password
2. The actor enters username and password
3. The system validates the entered username and password and logs the actor
into system

Alternative course of action: If actor enters invalid username and password then the system
display error message.
3. Use case name: create account
Actor(s): manger
Description: allow to create account to students and staff members
Precondition: only the manger can create an account to users
Basic course of action
1. The system requests the manger to enter the correct username and password
2. The manger enters username and password
3. The system validates the entered username and password and allows the
manger to create account .
4. The use case ends

Alternative course of action: If manger enters invalid username and password then the
system displays error message.

School of electrical and computer Enginerring June 20, 2016 27

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

4. Use case name: update account

Actor(s): manger
Description: allow to update account to students and staff members
Precondition: only manger can update the account to the users
Basic course of action
[Link] system requests the manger to enter the correct username and password
2. The manger enters username and password
3. The system validates the entered username and password and allows the
manger to update account .
4. The use case ends
Alternative course of action: If manger enters invalid username and password then the
system displays error message.
5. Use case name: view student detail
Actor(s): manger
Description: allow to see student information by using id number
Precondition: none
Basic course of action
1The system requests the manger to enter the correct username and password
2. The manger enters username and password
3. The system validates the entered username and password and allows the
manger to see student information .
4. The use case ends
Alternative course of action: If manger enters invalid username and password then the
system displays error message.
6. Use case name: delete account
Actor(s): manger
Description: allow to manger to delete account
Precondition: none

School of electrical and computer Enginerring June 20, 2016 28

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

Basic course of action

1The system requests the manger to enter the correct username and password
2. The manger enters username and password
3. The system validates the entered username and password and allows the
manger to see student information .
4. The use case ends
Alternative course of action: If manger enters invalid username and password then the system
displays error message.
7. Use case name: delete student information
Actor(s): proctor, police officer, café manger, library officer
Description: allow to the staff to delete student information if student is free from any
crime
Precondition: none

Basic course of action

1The system requests the staff (proctor, library officer, police officer, café officer) to enter the
correct username and password

2. Those staff member enters username and password

3. The system validates the entered username and password and allows the staff member to
delete student information
4. The use case ends
Alternative course of action: If staff member i.e (proctor, café manger, police manger) enters
invalid username and password then the system displays error message.
8. Use case name: search student information
Actor(s): proctor, library officer, café officer, library officer
Description: allow to the staff member i.e (proctor ,library officer, café manger, police
officer to allow search student information using first name, department, id-number
Precondition: none

School of electrical and computer Enginerring June 20, 2016 29

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

Basic course of action

1The system requests the staff member(proctor, police officer, library officer, café officer) to
enter the correct username and password
2. The staff member enters username and password
3. The system validates the entered username and password and allows the
staff members to search student information’s. .
4. The use case ends
Alternative course of action: If staff members (proctor, library officer, police officer, café
officer) enters invalid username and password then the system displays error message.
9. Use case name: register crime students
Actor(s): proctor officer, library officer, police officer, café officer
Description: allow to staff members (proctor officer, library officer, café officer, police
officer) to register crime students.
Precondition: if the student make the crime the staff members register the students

Basic course of action

1The system requests the staff members(proctor officer, library officer, café officer, police
officer) to enter the correct username and password
2. The manger enters username and password
3. The system validates the entered username and password and allows the
staff members to register crime students. .
4. The use case ends
Alternative course of action: If staff members (police officer, proctor officer, café officer,
library officer) enters invalid username and password then the system displays error message

School of electrical and computer Enginerring June 20, 2016 30

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

Sequence Diagram
A sequence diagram shows an interaction arranged in time sequence. In particular, it shows the
instances participating in the interaction by their “lifelines” and the stimuli that they arranged in
time sequence. It does not show the associations among the objects.

User Home Page User Login Login

<<actor>> <<UI>>, Login <<controler>> <<UI>> Database
Login: Basic course of action
for the the login
Wishes to open

click the login tab

Send()
1. Open home page of the system

2. click login tab <<creates>>

2. Enter username
and password Enter user name and password
Login()
3. The system check the eligibility of
user name and password from check

the database
Invalid

4. Redirect to the page

Redirect to the required page

Figure 9:Sequence Diagram-Login

School of electrical and computer Enginerring June 20, 2016 31

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

user
manager Home page Registration Application form
<<actor>> <<UI>> Regestration: <<controller>> <<UI>> Database

Apply Registration:: Basic

course of action
for the system.
Wish to registration

Click registration link

send()
1. manager wishes to create account.

<<create>>

fill the required information

2. manager input the
information using form screen
on the home page

apply
.
3. manager apply. submit()

cann't accept

4. view successful message Successfully registerd

Figure 10:Sequence Diagram-create user account

School of electrical and computer Enginerring June 20, 2016 32

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

Class Diagram
Class diagrams show the static structure of the model, in particular, the things that exist (such as
classes and types), their internal structure, and their relationships to other things

Figure 4: class diagram

Figure 11:class diagram for a system

School of electrical and computer Enginerring June 20, 2016 33

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

HOME PAGE

Figure 12:home page for a system

School of electrical and computer Enginerring June 20, 2016 34

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

background and mission

Figure 13:background and mission for jit

School of electrical and computer Enginerring June 20, 2016 35

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

LOGIN FORM

Figure 14:login form

School of electrical and computer Enginerring June 20, 2016 36

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

MANAGER HOME PAGE

Figure 15:manger home page

School of electrical and computer Enginerring June 20, 2016 37

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

TO CREATE ACCOUNT

Figure 16:to create account for user

MANAGER TO VIEW STUDENT INFORMATION

Figure 17:to view student information

School of electrical and computer Enginerring June 20, 2016 38

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

LIBRARIAN HOME PAGE

Figure 18:library home page

TO CHECK THE ACCOUNT

Figure 19:to check student id number

School of electrical and computer Enginerring June 20, 2016 39

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

THE VALID ACCOUNT

Figure 20:valid id number

STUDENT REGITRATION FOR LIBRARIAN

Figure 21:registration form for crime student in library

School of electrical and computer Enginerring June 20, 2016 40

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

STUDENT INFORMATION REGISTERD BY LIBRARIAN

Figure 22:student information in library

School of electrical and computer Enginerring June 20, 2016 41

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

police home page

Figure 23:home page for police home page

PROCTOR HOME PAGE

Figure 24:home page for proctor

School of electrical and computer Enginerring June 20, 2016 42

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

STUDENT HOME PAGE

Figure 25:home page for student

STUDENT CLEARANCE REQUEST

Figure 26:request page for student

School of electrical and computer Enginerring June 20, 2016 43

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

STUDENT CLEARANCE SLIP

Figure 27:clearance slip for students

As we seen the above clearance slip the system generate random code to differentiate
one student clearance paper from other it generates one random code per one id request
And the student prints this form and finally the manger stamp on clearance slip.

School of electrical and computer Enginerring June 20, 2016 44

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

chapter five
Conclusion and recommendation
5.1 conclusion
Currently, in Jimma University the student clearance system is going on based on manual or
traditional system. The project proposed a new supplementary solution for Jimma university
student clearance system. The supplement clearance system is targets on providing online
student clearance system, which will help to reduce the time, labor force, cost and resource
wastage that was found in the existing manual system and speeding up the registration process
by having right data.

School of electrical and computer Enginerring June 20, 2016 45

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

5.2 recommendation
In general, this project contributes an initial work on online clearance system for Jimma
University This work is not an end, and that needs to be matured in other similar projects in the
future to scale up it to more sophisticated technologies and techniques. From different the
various fact that constituents the project, the following recommendations are suggested.
The University will take these opportunities to entertain such an alternative student clearance
system. Serious attention should be given for the introduction of the new system. The University
should facilitate the communication infrastructures to the introduction of new system. Also it is
recommended that the any one should develop such system from this initiation.

Reference
[Link], bahrami, object oriented system development

School of electrical and computer Enginerring June 20, 2016 46

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

2. coad, peter. Nicola, jill object oriented programming. New York mcgraw-hill (1993)
3.[Link] system April 25 2016
4. [Link] application development method may 31 2016
[Link] case and functional requirements[Link] .com/[Link]
5. [Link] may 23 2016
7.[Link] UML 2 use case diagrams June 2 2016
8.[Link] may 26 2016
9. Software engineering principles and practices by Rohit Khurana ITL ESL Sommer Ville
Software Enginerring seven edition
10. Fundamental of Database System- Elmasri, Navathe, Somayajulu, Gupta-2nd Edition

Appendix
Sample Html code for Home page
<head>
<title>Online students Clearance System for Jimma University</title>

School of electrical and computer Enginerring June 20, 2016 47

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

<meta name="description" content="free website template" />

<meta name="keywords" content="enter your keywords here" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="css/[Link]" />
<script type="text/javascript" src="js/[Link]"></script>
<script type="text/javascript" src="js/image_slide.js"></script>
<style type="text/css">
<!--
.style1 {
font-family: "Times New Roman", Times, serif;
font-weight: bold;
font-size: medium;
}
-->
</style>

<script type="text/javascript" >

</script>

</head><body>
<div id="main">
<div id="header">
<div id="banner">

<!--<div id="welcome_slogan"> -->

<img width="918" height="105" src="images/danland_logo.jpg">

School of electrical and computer Enginerring June 20, 2016 48

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

<!--</div> <!--close welcome_slogan-->

</div><!--close banner-->
</div><!--close header-->
<div id="navigation">
<ul>
<li class="current">
<div align="left"><a href="[Link]">Home</a></div>
</li>

<li>
<div align="left"><a href="[Link]">About Us </a>
<ul class="sub-menu">
<li>
<div align="left"><a href="[Link]">Background</a></div>
</li>
<li>
<div align="left"><a href="[Link]">Misson</a></div>
</li>
</ul>
</div>
Php code for manger home
<head>
<title>Manager Home</title>
<meta name="description" content="free website template" />
<meta name="keywords" content="enter your keywords here" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="css/[Link]" />
<script type="text/javascript" src="js/[Link]"></script>

School of electrical and computer Enginerring June 20, 2016 49

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

<script type="text/javascript" src="js/image_slide.js"></script>

<style type="text/css">
<!--
.style5 {font-size: medium; font-family: "Times New Roman", Times, serif; font-
weight: bold; }
.style7 {
font-size: medium;
font-style: italic;
font-weight: bold;
font-family: "Times New Roman", Times, serif;
color: #000099;
}
.style8 {color: #fff}
-->
</style>
<script type="text/javascript">
tday =new
Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturd
ay");
tmonth=new
Array("January","February","March","April","May","June","July","August","Sept
ember","October","November","December");

function GetClock(){
d = new Date();
nday = [Link]();
nmonth = [Link]();
ndate = [Link]();
nyear = [Link]();
nhour = [Link]();

School of electrical and computer Enginerring June 20, 2016 50

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

nmin = [Link]();
nsec = [Link]();

if(nyear<1000) nyear=nyear+1900;

if(nhour == 0) {ap = " AM";nhour = 12;}

else if(nhour <= 11) {ap = " AM";}
else if(nhour == 12) {ap = " PM";}
else if(nhour >= 13) {ap = " PM";nhour -= 12;}

if(nmin <= 9) {nmin = "0" +nmin;}

if(nsec <= 9) {nsec = "0" +nsec;}

[Link]('clockbox').innerHTML=""+tday[nday]+",
"+tmonth[nmonth]+" "+ndate+", "+nyear+"
"+nhour+":"+nmin+":"+nsec+ap+"";
setTimeout("GetClock()", 1000);
}
Php code for student home page
<head>
<title>Librarian Home</title>
<meta name="description" content="free website template" />
<meta name="keywords" content="enter your keywords here" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="css/[Link]" />
<script type="text/javascript" src="js/[Link]"></script>
<script type="text/javascript" src="js/image_slide.js"></script>
<style type="text/css">

School of electrical and computer Enginerring June 20, 2016 51

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

<!--
.style5 {font-size: medium; font-family: "Times New Roman", Times, serif; font-
weight: bold; }
.style7 {
font-size: medium;
font-style: italic;
font-weight: bold;
font-family: "Times New Roman", Times, serif;
color: #000099;
}
.style8 {color: #fff}
-->
</style>
<script type="text/javascript">
tday =new
Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturd
ay");
tmonth=new
Array("January","February","March","April","May","June","July","August","Sept
ember","October","November","December");

function GetClock(){
d = new Date();
nday = [Link]();
nmonth = [Link]();
ndate = [Link]();
nyear = [Link]();
nhour = [Link]();
nmin = [Link]();
nsec = [Link]();

School of electrical and computer Enginerring June 20, 2016 52

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

if(nyear<1000) nyear=nyear+1900;

if(nhour == 0) {ap = " AM";nhour = 12;}

else if(nhour <= 11) {ap = " AM";}
else if(nhour == 12) {ap = " PM";}
else if(nhour >= 13) {ap = " PM";nhour -= 12;}

if(nmin <= 9) {nmin = "0" +nmin;}

if(nsec <= 9) {nsec = "0" +nsec;}

[Link]('clockbox').innerHTML=""+tday[nday]+",
"+tmonth[nmonth]+" "+ndate+", "+nyear+"
"+nhour+":"+nmin+":"+nsec+ap+"";
setTimeout("GetClock()", 1000);
}
[Link]=GetClock;
</script>
</head>

<body>
<div id="main">
<?php
if (!isset($_SESSION)) {
session_start();
}
?>
<div id="header">

School of electrical and computer Enginerring June 20, 2016 53

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

<div id="banner">

<!--<div id="welcome_slogan"> -->

<img width="918" height="105" src="images/danland_logo.jpg">

<!--</div> <!--close welcome_slogan-->
</div><!--close banner-->
</div><!--close header-->
<div id="navigation">
<ul>
<li class="current"><a href="[Link]">Home</a></li>
<li><a href="[Link]">About Us </a>
<ul class="sub-menu">
<li><a href="[Link]">Background</a></li>
<li><a href="[Link]">Misson</a></li>
</ul>
</li>
<li><a href="[Link]">Request</a>
</li>
<li><a href="[Link]">Contact Us</a></li>
</ul>
</div><!--close menubar-->
<div id="sub-menu">
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

School of electrical and computer Enginerring June 20, 2016 54

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

<?php
echo "<b>".date('l\, F jS\, Y ')."</b>";
?>
</div>
<div id="site_content">
<ul class="slideshow">
<li class="show"><img width="880" height="250" src="images/[Link]"
alt="&quot;Jimma University Logo &quot;" /></li>
<li><img width="880" height="250" src="images/[Link]"
alt="&quot;Jimma University&quot;" /></li>
<li><img width="880" height="250" src="images/[Link]"
alt="&quot;Jimma University &quot;" /></li>
<li><img width="880" height="250" src="images/[Link]"
alt="&quot;Jimma University&quot;" /></li>
<li><img width="880" height="250" src="images/[Link]"
alt="&quot;Jimma University &quot;" /></li>
</ul>
</div><!--close header-->

<div id="site_content">

<div class="sidebar_container">
<!--close sidebar-->
<div class="sidebar">
<div class="sidebar_item">

<h2> <a href="[Link]" class="style8">Logout</a></h2>

<p>

School of electrical and computer Enginerring June 20, 2016 55

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

<?php
$t=0;
$con=mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("cdb", $con) or
die(mysql_error($con));
$q='SELECT Email,FirstName from account';
$r=mysql_query($q,$con);
while($row=mysql_fetch_array($r)){
if(($row[0]==$_SESSION['user'] &&
isset($_SESSION['logged'])))
{
$t=1;
print "Welcome
"."<b><u>".$row[1]."<u></b>.<br/>";
print "Date is: ";

echo "<b>".date('l\, F jS\, Y ')."</b>";

}
}
if($t==0){
header('location:[Link]');
}

?>
</p>
<p>&nbsp; </p>

School of electrical and computer Enginerring June 20, 2016 56

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

</div>
<div class="sidebar_item">
<h2>Announcements</h2>
<h3>May 2016 </h3>
<p>The final implemntation of this project will finished at the mid week of
may 2016. So the project...</p>
</div><!--close sidebar_item-->
</div><!--close sidebar-->
<!--close sidebar-->
</div>
<!--close sidebar_container-->

<div id="content">
<div class="content_item">
<h1>Student Homepage </h1>
<form id="form1" method="post" action="">
<fieldset>
<legend class="style7">Welcome </legend>
<p>&quot; &quot; you are login as Student </p>
</fieldset>
</form>
</div>
<!--close content_item-->
</div><!--close content-->
</div><!--close site_content-->

<div id="content_grey">
<div class="content_grey_container_box">

School of electrical and computer Enginerring June 20, 2016 57

 ONLINE STUDENT CLEARANCE SYSTEM FOR JIT

<h4>Events &amp; Announcements</h4>

<p> </p>
<div class="readmore">
<a href="#">Read more</a>
</div><!--close readmore-->
</div><!--close content_grey_container_box-->
<div class="content_grey_container_box">
<h4>Latest News</h4>
<p></p>
<div class="readmore">
<a href="#">Read more</a>
</div><!--close readmore-->
</div><!--close content_grey_container_box-->
<div class="content_grey_container_boxl">
<h4>Latest Projects</h4>
<p> </p>
<div class="readmore">
<a href="#">Read more</a>
</div><!--close readmore-->
</div><!--close content_grey_container_box1-->
<br style="clear:both"/>
</div><!--close content_grey-->

School of electrical and computer Enginerring June 20, 2016 58