Question-41

DBMS

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 \(\text{commission} \le 50000\), enhance it by 2%

If \(50000\lt \text{commission} \leq 100000\), enhance it by 4%

If \(\text{commission} \gt 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 salesinfo 
SET commission = commission * 1.02 
WHERE commission <= 50000;

T2:

UPDATE salesinfo 
SET commission = commission * 1.04 
WHERE commission > 50000 and commission is <= 100000;

T3:

UPDATE salesinfo 
SET commission = commission * 1.06 
WHERE commission > 100000;

Which of the following options of running these transactions will update the commission of all salespersons correctly