A company maintains records of sales made by its salespersons and pays them commission based on each individual's total sales made in a year. This data is maintained in a table with following schema:salesinfo = (salespersonid, totalsales, commission)In a certain year, due to better business results, the company decides to further reward its salespersons by enhancing the commission paid to them as per the following formula:If commission < = 50000, enhance it by 2% If 50000 < commission < = 100000, enhance it by 4% If commission > 100000, enhance it by 6%The IT staff has written three different SQL scripts to calculate enhancement for each slab, each of these scripts is to run as a separate transaction as follows: T1 Update salesinfoSet commission = commission * 1.02Where commission < = 50000; T2 Update salesinfoSet commission = commission * 1.04Where commission > 50000 and commission is < = 100000; T3 Update salesinfoSet commission = commission * 1.06Where commission > 100000; Which of the following options of running these transactions will update the commission of all salespersons correctly?

• A. Execute T1 followed by T2 followed by T3
• B. Execute T2, followed by T3; T1 running concurrently throughout
• C. Execute T3 followed by T2; T1 running concurrently throughout
• D. Execute T3 followed by T2 followed by T1