Design and Development of a Leave Management System for Efficient Employee Leave Tracking Using C# and SQL
Kankani Pathirannehelage, Dalsi Samarathunga (2025)
2025
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2025112529766
https://urn.fi/URN:NBN:fi:amk-2025112529766
Tiivistelmä
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.
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.