Reporting and functionality addition for time-tracking system
Oat, Elena (2012)
Oat, Elena
Turun ammattikorkeakoulu
2012
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-201205249721
https://urn.fi/URN:NBN:fi:amk-201205249721
Tiivistelmä
The purpose of this study was to implement additional features to a configured time-tracking system used in a company. The desired functionality included automatic clock-out of the employees and reporting features. The main goal of the thesis consisted of creating an “interface” between end user application and database. Therefore, execution of SQL queries from application object-oriented code was avoided. Transact-SQL stored procedures written for Microsoft SQL Server 2008 R2 constitute components of the “interface”. Procedures were written using the set-based approach which ensures conciseness of code and fast processing time.