Designing a Payroll System Database for Staff of the Informatics Engineering Department of Universitas Muhammadiyah Yogyakarta

Nisrina Akbar Rizky Putri, Slamet Riyadi, Aprilia Kurnianti

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.


Keywords


payroll system, access policies, anomaly check, view check.

Full Text:

PDF

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




DOI: https://doi.org/10.18196/eist.v1i3.13157

Refbacks

  • There are currently no refbacks.


Editorial Office:

EMERGING INFORMATION SCIENCE AND TECHNOLOGY

Department of Information Technology, Faculty of Engineering,

Universitas Muhammadiyah Yogyakarta.

Jln. Brawijaya Tamantirto Kasihan Bantul 55183 Indonesia

Telp:(62)274-387656, Fax.:(62)274-387656

Website: http://journal.umy.ac.id/index.php/eist