Disadvantages of business rules and transactions constraints in SQL

Business and transaction constraints are used by a database for applying specific business rules. For Example, an order cannot be accepted for items which has limited inventory and if an order is deleted, there should be changes to other columns. However, there are few disadvantages of business rules and transactions constraints:

1) Not consistent: There can be many programs written by different programmers to apply rules for business and transaction processing. This can lead to inconsistency in the database.

2) Duplicate codes and programs: There can be many different programs and codes which are used for making changes to a particular table.

3) Complex system: Since there are many different rules in the system, it becomes complex over time.

4) Problem with editing codes: If there has to be a change in a particular business rules and transactions constraint, then it’s a difficult task to locate the code for that particular business rule. Also, while changing the code a programmer has to make sure that the change does not interfere with the other business rules and transactions.

Leave a Reply