Business Rules Handling in Relational Databases

Business rules handling is very essential for organization's operational needs. In order to increase efficiency and optimize operational cost, many organizations try to convert their business process into a computer-based system. Therefore, we need a model of business rule in order to maintain the business rules in the system. The aim of this paper is to capture business rules into the computer-based system, particularly on modeling the business rules in the relational model. First-order logic notation will be applied as an approach to model the business rules. This model will be used to store business rules in the database and also to check the data instances in operational databases. The checking results will be reported in the form of log files. As a result of a data checking process, the system can determine whether a data instance comply with the business rules or not.