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

Nisrina Akbar Rizky Putri (Universitas Muhammadiyah Yogyakarta)
Slamet Riyadi (Universitas Muhammadiyah Yogyakarta)
Aprilia Kurnianti (Universitas Muhammadiyah Yogyakarta)

Emerging Information Science and Technology
Vol 1, No 3: August 2020

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.