Magister of Informatics Engineering of The College of Information Systems and Computer Science AMIKOM, Ring Road Utara ST, Condong Catur, Depok Sleman Yogyakarta Indonesia

---

Abstract—Database plays important role on both web-based or desktop-based information system. Nowadays web-based information systems dominate information system application. Relational database systems such as Oracle, MySQL, MS SQL Server or PostgreSQL are familiarly used as data base management system. In Indonesia almost all academic information systems at higher education institutions are web-based application with RDBMS as database software. Some researches show the lack of data input validation that makes problem on data security and data quality. Input sanity is a problem that needs a serious attention. Data validation can be done by making a constraint in the database or application level. The fact is that validation in database level is less done by programmers. This research will perform the analysis of advantages or disadvantages from CHECK constraint on database table of academic information system.

Index Terms—CHECK constraint, input validation, input benchmark, data quality, academic database

[PDF]

Cite: Ema Utami, "The Advantages of Using CHECK Constraints in The Academic Database Tables," Journal of Software vol. 9, no. 2, pp. 382-388, 2014.