Designing a Payroll System Database for Staff of the Informatics Engineering Department of Universitas Muhammadiyah Yogyakarta
DOI:
https://doi.org/10.18196/eist.v1i3.13157Keywords:
payroll system, access policies, anomaly check, view check.Abstract
The development of a staff payroll system aims to create a system that can help an administrator recapitulate attendance and payroll data of Informatics Engineering (IE) Department staff quickly and accurately. Such a development requires a database. The database design is divided into four stages: requirement collection and analysis, conceptual database design, logical database design, and physical database design. Design testing was performed on the database by testing the access policies, anomaly check, and view check. The results reveal that the proposed system worked well did not encounter anomalies.
References
Abdillah, L. A. (2013). “Perancangan basisdata sistem informasi penggajian [Designing a payroll information system database]”. arXiv preprint arXiv:1302.0337.
R. Hadi and R. Idmayanti, “Sistem Informasi Akademik Berbasis Web Menggunakan Pendekatan Berorientasi Objek pada Jurusan Teknologi Informasi Politeknik Negeri Padang [Web-Based Academic Information System Using an Object-Oriented Approach in the Department of Information Technology, Politeknik Negeri Padang],” Elektron: Jurnal Ilmiah, vol. 4, no. 2, pp. 95–102, 2012.
Mulyadi, M. (2017). “Implementasi Sistem Basis Data Untuk Mendukung Pengembangan Sistem Informasi Manajemen Sumber Daya Manusia (Studi Kasus: Stikom Dinamika Bangsa) [Implementation of Data Based Systems to Support the Development of Human Resource Management Information System (Case Study: Stikom Dinamika Bangsa)]”. Jurnal Ilmiah Media Sisfo, 8(2), 45–60..
H.-L. Lee, “What is a collection?,” Journal of the American Society for Information Science, vol. 51, no. 12, pp. 1106–1113, 2000.
M. Gallagher, “Data collection and analysis,” Researching with children and young people: Research design, methods and analysis, pp. 65–127, 2009.
D. T. Griffee, “Research Tips: Interview Data Collection.,” Journal of Developmental Education, vol. 28, no. 3, pp. 36–37, 2005.
E. Bleich and R. Pekkanen, “How to report interview data,” Interview research in political science, vol. 1, pp. 84–105, 2013.
C. Beeri, P. A. Bernstein, and N. Goodman, “A sophisticate’s introduction to database normalization theory,” in Readings in Artificial Intelligence and Databases, Elsevier, 1989, pp. 468–479.
M. Demba, “Algorithm for relational database normalization up to 3NF,” International Journal of Database Management Systems, vol. 5, no. 3, p. 39, 2013
H. K. Al-Masree, “Extracting Entity Relationship Diagram (ERD) from relational database schema,” International Journal of Database Theory and Application, vol. 8, no. 3, pp. 15–26, 2015.
M. Rumapea et al., "Evaluation of Internal Control of Payroll System in Hospital," 2019 International Conference of Computer Science and Information Technology (ICoSNIKOM), 2019, pp. 1-4.
L. Zhuang and J. Zheng, "Design and Implementation of Accurate Payroll Retroactive Accounting Based on SAP Payroll Architecture," 2012 International Conference on Computing, Measurement, Control and Sensor Network, 2012, pp. 384-387.
A. Rehman and N. A. Zafar, "NFA based formal verification of automatic payroll processing system," 2016 International Conference on Emerging Technologies (ICET), 2016, pp. 1-6.
M. I. Hossain and M. M. Ali, "SQL query based data synchronization in heterogeneous database environment," 2012 International Conference on Computer Communication and Informatics, 2012, pp. 1-5.
W. Khan, W. Ahmad, B. Luo and E. Ahmed, "SQL Database with physical database tuning technique and NoSQL graph database comparisons," 2019 IEEE 3rd Information Technology, Networking, Electronic and Automation Control Conference (ITNEC), 2019, pp. 110-116
Downloads
Published
Issue
Section
License
Copyright
The author should be aware that by submitting an article to this journal, the article's copyright will be fully transferred to journal of Emerging Information Science and Technology. Authors are allowed to resend their manuscript to other journals or intentionally withdraw the manuscript only if both parties (journal of Emerging Information Science and Technology and Authors) have agreed on the issue. Once the manuscript has been published, authors are allowed to use their published article under journal of Emerging Information Science and Technology's copyrights.
All authors are required to deliver the agreement of license transfer once they submit the manuscript to journal of Emerging Information Science and Technology. By signing the agreement, the copyright is attributed to this journal to protect the intellectual material for the authors. Authors are allowed to share, copy and redistribute the material in any medium and in any circumstances to give appropriate credit and wide readership to the work.
License
Articles published in the journal of Emerging Information Science and Technology are licensed under an Attribution 4.0 International (CC BY 4.0) license. You are free to:
- Share — copy and redistribute the material in any medium or format.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
This license is acceptable for Free Cultural Works. The licensor cannot revoke these freedoms as long as you follow the license terms. Under the following terms:
- Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
