CONSTRAINT BASIS DATA SEBAGAI FONDASI YANG KUAT DALAM PENGEMBANGAN SISTEM INFORMASI

ABSTRAK Database is play important roles in computer based information system. Almost computer based information system will used database to store the data and information. Relational database management system (RDBMS) is one of database management system widely used in information system to storing data. RDMS such as Oracle, MS SQL Server, PostgreSQL, DB2 and MySQL are well known database management system use in information system. Information system will collects, process and stores data from organization’s resources for many purposes that supports the management functions of organization. The strored data must be good, clean, correct and valid data, free from garbage to support the functional of information system, data validation is a choice that can be done. Data validation can be done into two approaches application software code or database constraints. Many information system will using application software code to validate the data, application software usually developed using PHP, Delphi, VB or others. Only fewer information system application use database constraints to validate data, the study will show benefit of using database constraints to protect un-correct data enter into a system