What is the field of study of Z?

Draw a table with Student, Collage (Institute) and Subject.
R studies in the same college as P, who studies MBA in college B.
T studies BCA in college A and his brother W studies Aviation Technology in college C.
S studies Journalism in the same college as Q.
Neither R nor Z studies BCA.
The girl who studies BCA does not study in college C.
No girl studies Journalism or MBA.
Two of the seven students study BCA, two study medicine and one each studies Aviation Technology, Journalism and MBA.
Assume + sign is for Boys and - sign is for girls.
Based on the above information, The classification of the group is as follow in the table.