doi: 10.4304/jsw.9.2.382-388
The Advantages of Using CHECK Constraints in The Academic Database Tables
- 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-basedor desktop-based information system. Nowadays web-basedinformation systems dominate information system application.Relational database systems such as Oracle, MySQL,MS SQL Server or PostgreSQL are familiarly used as database management system. In Indonesia almost all academicinformation systems at higher education institutions areweb-based application with RDBMS as database software.Some researches show the lack of data input validationthat 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 thedatabase or application level. The fact is that validation indatabase level is less done by programmers. This researchwill perform the analysis of advantages or disadvantagesfrom CHECK constraint on database table of academicinformation system.
Keywords
- CHECK constraint
- input validation
- inpu
How to 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. https://doi.org/ 10.4304/jsw.9.2.382-388
Copyright & License
Copyright © 2014 by the authors. This is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited (CC BY 4.0).