Q12Multiple correct4 Marks22 Dec 2024
The following pseudocode is executed using the "Shopping bills" dataset. Assume each customer has distinct name.
```
A = 1, N = 1000, count = 0
while(Table 1 has more rows){
Read the first row X in Table 1
Move X to Table 2
while(Table 1 has more rows){
Read the first row Y in Table 1
if(X.CustomerName == Y.CustomerName){
A = A + 1
Move Y to Table 2
}
else{
Move Y to Table 3
}
}
if(A < N){
N = A
}
A = 1
count = count + 1
Move all rows from Table 3 to Table 1
}
```