Web-Based Student Result Management System: October 2018
Web-Based Student Result Management System: October 2018
Web-Based Student Result Management System: October 2018
net/publication/318215858
CITATIONS READS
0 35,536
1 author:
SEE PROFILE
Some of the authors of this publication are also working on these related projects:
All content following this page was uploaded by Mohammad Gulam Lorgat on 22 December 2020.
Abstract: The technological development and impact of computers and internet on our lives
that has been verified over time affected various sectors of activity. And almost every task
today is being run through computers. Getting information and quickly turning it into a product
that consumers want is the essential key to staying in business and all of this is done nowadays
using computers and applications or information systems. And the education system is
undeniably the backbone of the society, it focusses at preparing the young talents for the future.
However, currently the process of students’ result management and declaration at the Catholic
University of Mozambique, is performed manually with extensive human intervention, the
students’ results are generated through a spreadsheet application and then printed on a paper,
attached to a wall for declaration and then stored. The current research aims at creating a web-
based student result management system, reducing time, effort and improving security. The
methodology adopted for the elaboration of the research is based on qualitative study. The
research results in the development of a multi-user system, based on web technology with
MVC (Model-View-Controller) architectural pattern and developed using Java programming
language with Apache Tomcat Server and MySQL Database Management System support.
1 Introduction
The impact of computers and internet, on our lives today is probably much more than
we really know. Getting information and quickly turning it into a product that
consumers want is the essential key to staying in business and all of this is done
nowadays using computers and applications or information systems.
And the information systems will continue to change businesses and the way we
live. Many corporate leaders are using technology to manage every aspect of their
organization, from product creation to customer service.
It has brought evolution in almost every field, it changed the ways of teaching,
administration of activities such as e-learning, e-library and online portals where
teachers and students communicate, and sharing of information has never been better.
Student result declaration and management are amongst the most important
activities within a university or any educational institution, since all other activities
depend on it. Hence implementing an information system can be declared a
significance result.
The main objective of this research is to enhance and automate the management and
declaration of students’ results using a computerized system.
1.2 Scope
The study aims at developing and implementing a web-based student result
management system for the Catholic University of Mozambique, replacing the old
manually done paper work and to minimize the security issues and the problems it
possesses.
The proposed is a multi-user system, developed using Java programming
language with Apache Tomcat Server and MySQL DBMS (Database Management
System) support.
The system is confined to and intended for the students. They possess privileges
to check their results after he/she is provided with a specific username and password
for a secure login. The entire system is managed by a system administrator, who
possesses the full control of the system, to read, write and execute the results and to
assign privileges to teachers and students. And the teachers have the privilege to
assign the students’ marks, through which, a result will be generated automatically
and each student will have access to their results only, using their respective account.
3 Research Methodology
A research methodology is the elaboration of a clear strategy for gathering evidence,
including the specific data collection methods to be used, the kinds of evidence to be
collected, and the approach for analysing the evidence (Darian-Smith & McCarthy,
2017). It is the path to solve a research problem. Hence it must be planned according
to the objectives of the study.
5 System Design
The purpose of the analysis phase is to figure out what the business needs and right
after system analysis, started system design whose purpose is to decide how to build
the same system. And according to Dennis et al. (2015), system design is the
determination of the overall system architecture, consisting of a set of physical
processing components, hardware, software, people, and the communication among
them, that will satisfy the system’s essential requirements. During the initial part of
design, the business requirements for the system are converted into system
requirements that describe the technical details for building the system.
Second normal form is satisfied if any one of the following conditions apply:
• The primary key consists of only one attribute (such as the attribute ID in
relation USER).
• No nonprimary key attributes exist in the relation.
• Every nonprimary key attribute is functionally dependent on the full set of
primary key attributes.
For example, the following table is not in 2NF:
STUDENT (UserID, Name, Password, Level, SubjectID, description)
The functional dependencies in this relation are the following:
UserID – Name, Password, Level
UserID, SubjectID – description
The primary key for this relation is the composite key UserID, SubjectID.
Therefore, the nonprimary key attributes Name, Password, and Level are functionally
dependent on only UserID but not on SubjectID. STUDENT table has redundancy,
which results in problems when the table is updated.
And now to convert a relation to second normal form, the relation is decomposed
into new relations using the attributes, called determinants, that determine other
attributes; the determinants are the primary keys of these relations. STUDENT table is
decomposed into the following two relations:
USER (UserID, Name, Password, Level)
Subject (SubjectID, description)
And the third normal form (3NF) is satisfied if: It is in second normal form and there
are no functional dependencies between two (or more) nonprimary key attributes (a
functional dependency between nonprimary key attributes is also called a transitive
6 System Implementation
7 Conclusions
The present research was based on the computerization and the implementation of a
sophisticated Web-Based Student Result Management System for the Catholic
University of Mozambique. The main objective was to enhance and automate the
management and declaration of students’ results using a computerized system. A
well-defined, efficient, controlled and managed information system or software based
on web technology storing, processing and providing information through the
internet.
And the objectives were achieved by following a process model such as system
analysis, design and system implementation. The system analysis was composed of
two activities, requirement determination and structuring. The first activity focused on
the collection of data or requirements through structured interview, work environment
observation and by collecting procedures and other written documents. And the latter,
performed the modelling of the collected data and processes, transforming it into
UML diagrams with the aid of a UML modelling tool, Astah into a graphically
understandable manner. Just as structured analysis uses DFDs (Data Flow Diagrams)
to model data and processes, systems analysts use UML to describe Object Oriented
systems, on which the current system is based. UML is independent of any specific
programming language and can be used to describe business processes and
requirements generally. Finally, the implementation or coding of the proposed system
was based on the software architecture standard, MVC using Java programming
language, which is based on the object-oriented paradigm.
8 Future Work
In near future, the system interface could be improved, with more attractive,
interactive and meaningful images; Enhance the system with an email and SMS
(Short Message Service) or email notifications; Enhance the current system by
computerizing almost all of the services provided by the institution (online exams,
enrolment, library and others), turning it into a complete LMS; And evolve the system
Acknowledgements
Immense gratitude to the colleagues from Catholic University of Mozambique (UCM)
– Faculty of Engineering, who provided insight and expertise that greatly assisted the
research.
References
Darian-Smith, E., & McCarthy, P. (2017). The Global Turn. Oakland, CA: University of
California Press.
Dawson, C. (2015). Projects in Computing and Information Systems (3rd ed.). Harlow,
England: Pearson.
Dennis, A., Wixom, B. H., & Tegarden, D. (2015). Systems Analysis and Design (5th ed.).
Hoboken, NJ: Wiley Publishing.
Dias, S. B., Diniz, J. A., & Hadjileontiadis, L. J. (2014). Towards an Intelligent Learning
Management System Under Blended Learning. Cham, Switzerland: Springer.
https://doi.org/10.1007/978-3-319-02078-5
Dooley, J. (2017). Software Development, Design and Coding (2nd ed.). Galesburg, IL: Apress.
Foreman, S. (2018). The LMS Guidebook. Alexandria, VA: ATD Press.
Freund, S. M., Last, M. Z., Pratt, P. J., Sebok, S. L., Vermaat, M., Campbell, J. T., &
Frydenberg, M. (2017). Discovering computers and Microsoft Office 365, Office 2016. Boston:
Cengage Learning.
Sommerville, I. (2016). Software Engineering (10th ed.). Boston: Pearson.
Tilley, S. R., & Rosenblatt, H. J. (2017). Systems Analysis and Design (11th ed.). Boston:
Cengage Learning.
Valacich, J. S., & George, J. F. (2017). Modern Systems Analysis & Design (8th ed.). Boston:
Pearson.
Wallace, P. (2015). Introduction to Information Systems (2nd ed.). Boston: Pearson.
Wundenberg, S.-M. (2015). Requirement Engineering for Knowledge-Intensive Processes:
Reference Architecture for the Selection of a Learning Management System. Wiesbaden,
Germany: Springer Gabler. https://doi.org/10.1007/978-3-658-08832-3