View in EDS

Design and Development of a Leave Management System for Efficient Employee Leave Tracking Using C# and SQL

Saved in:
Bibliographic Details
Title: Design and Development of a Leave Management System for Efficient Employee Leave Tracking Using C# and SQL
Authors: Kankani Pathirannehelage, Dalsi Samarathunga
Publication Year: 2025
Collection: Theseus.fi (Open Repository of the Universities of Applied Sciences / Ammattikorkeakoulujen julkaisuarkisto)
Subject Terms: fi=Tietojenkäsittely|sv=Informationsbehandling|en=Business Information Technology, databases, data security, data systems, database programs, applications (computer programmes), usability, small and medium-sized enterprises, management (control), planning and design, SQLite, Business Administration in Computer Applications
Description: This thesis was aimed at designing and developing a Leave Management System to the small and medium sized enterprises in Sri Lanka, to overcome the inefficiencies of the manual leave management system. Manual systems are characterized by delays and data errors as well as lack of transparency. Organizations can become more efficient and accurate in their human resource process by utilizing digital solutions. The thesis was based on three research questions: the advantages of automated LMS over manual processes, principles of database design to provide data security and accuracy, and the importance of role-based access control and a convenient interface to enhance the usability and efficiency of the system. The thesis is also practical in character and is development oriented. To begin with, the corresponding concepts that were associated with digital HR systems, database design, and RBAC were outlined. The Waterfall development model was then used to explain the system development process. LMS has been developed based on C# programming language and SQLite database. The implementation entailed the development of the design of a system, programming modules, and testing tasks by unit and integration testing. No individual data was gathered, rather, test data was created to ensure that the system was proven. The study shows that the resulting LMS enhanced speed, transparency, and efficiency of leave management as opposed to the manual processes. Normalization and ER modelling provided the guarantee of the correct and safe data processing, and the usage of RBAC helped to enhance security and usability by establishing the differentiation of roles of employees and managers. It has been suggested based on these findings that SMEs should consider using comparably inexpensive, lightweight LMS solutions to enhance their digital transformation efforts. Mobile access, cloud integration, analytics and multilingual capabilities may be added to the future development to improve the scalability and accessibility.
Document Type: bachelor thesis
Language: English
Relation: http://www.theseus.fi/handle/10024/902231
Availability: http://www.theseus.fi/handle/10024/902231
Rights: fi=All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.|sv=All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.|en=All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.|
Accession Number: edsbas.E2A55D1
Database: BASE
Description
Abstract:This thesis was aimed at designing and developing a Leave Management System to the small and medium sized enterprises in Sri Lanka, to overcome the inefficiencies of the manual leave management system. Manual systems are characterized by delays and data errors as well as lack of transparency. Organizations can become more efficient and accurate in their human resource process by utilizing digital solutions. The thesis was based on three research questions: the advantages of automated LMS over manual processes, principles of database design to provide data security and accuracy, and the importance of role-based access control and a convenient interface to enhance the usability and efficiency of the system. The thesis is also practical in character and is development oriented. To begin with, the corresponding concepts that were associated with digital HR systems, database design, and RBAC were outlined. The Waterfall development model was then used to explain the system development process. LMS has been developed based on C# programming language and SQLite database. The implementation entailed the development of the design of a system, programming modules, and testing tasks by unit and integration testing. No individual data was gathered, rather, test data was created to ensure that the system was proven. The study shows that the resulting LMS enhanced speed, transparency, and efficiency of leave management as opposed to the manual processes. Normalization and ER modelling provided the guarantee of the correct and safe data processing, and the usage of RBAC helped to enhance security and usability by establishing the differentiation of roles of employees and managers. It has been suggested based on these findings that SMEs should consider using comparably inexpensive, lightweight LMS solutions to enhance their digital transformation efforts. Mobile access, cloud integration, analytics and multilingual capabilities may be added to the future development to improve the scalability and accessibility.