Q4Single correct6 Marks28 Apr 2024

Let X and Y be two rows in the "Scores" table. We call X and Y partially matching if student X and Y either have the same gender or are from the same city, but not both. Let partialMatch(X, Y) be a procedure to find whether X and Y are partially matching. Choose the correct implementation of the procedure partialMatch.

A

``` Procedure partialMatch(X, Y) A = False, B = False if(X.Gender == Y.Gender){ A = True } if(X.Town/City == Y.Town/City){ B = True } if(A and B){ return(True) } return(False) End partialMatch ```

B

``` Procedure partialMatch(X, Y) A = False, B = False if(X.Gender == Y.Gender){ A = True } if(X.Town/City == Y.Town/City){ B = True } if(A or B){ return(True) } return(False) End partialMatch ```

C

``` Procedure partialMatch(X, Y) A = False, B = False if(X.Gender == Y.Gender){ A = True } if(X.Town/City == Y.Town/City){ B = True } if(not(A and B) and (A or B)){ return(True) } return(False) End partialMatch ```

D

``` Procedure partialMatch(X, Y) A = False, B = False if(X.Gender == Y.Gender){ A = True } if(X.Town/City == Y.Town/City){ B = True } if((A and B) and not(A or B)){ return(True) } return(False) End partialMatch ``` ————————————————————————————————————————————————————————————