Let's take a look at the following cases:
- Buying a contract phone is more expensive than a full price phone.
- Buying a CPU/Motherboard combo is more expensive than buying them separately.
- The discount for frequent flyers who made an early reservation is less than frequent flyers who made a late reservation.
Weird? Absurd business logic is generally introduced due to the increasing complexity of business operations. In order to make the business rational, it is important to apply strategic decision-making skills. Decision table can help here.
Case Study - Airline Discount
Airfare is a very complicated system. There are so many factors, along with many possible combinations of these factors that may affect the fare. Without a thoughtful analysis of all the factors, it is difficult to implement a pricing structure that is beneficial to both the customer and to the airline. As an airline, QAL is facing this problem.
QAL has long been documenting and managing its airfare pricing structure with document files. Updates were made to the documents for any change to the policy.
The operation manager of QAL thinks that there must be certain rules conflicting with each other. He wants to study the current policy but he finds it hardly possible because the document that records the policy has become a very long one with regulations and rules listing in a mess. Let's take a look at the document:
In order to find out the problem policy, he decided to represent the rules in the form of a decision table. Here is the decision table he developed:
By studying the fifth and the sixth rule, he discovered that frequent flyer who made an early reservation will receive a 15% discount while frequent flyer who made late reservation will receive 5% more, which does not make sense at all. So he managed to refine the policy, review the change he made by comparing the rules and finally updated the information system for this change.
Try it out
- Download the decision table sample project.
- Start Visual Paradigm and open the downloaded project file.
- Open the decision table.
- Press on the column header of rule 5. Drag to rule 6 to perform a multiple selection.
- By studying these business rules, you can easily find the problem - Frequent flyers who make an early reservation enjoy less discount than frequent flyers who make late reservation.
- Let's correct the business decisions by updating the business actions. Offer 15% discounts to general frequent flyers and 20% for frequent flyers who make an early reservation.
Decision table helps to convert complex business rules into easy-to-read format. Readers can look-up and think over the business decisions without difficulties. When multiple rules are placed adjacent to each other, conditions and actions can be easily compared, non-sense rules can be figured out and rectified easily and accurately.