Varing Hirarchical Query

Dear all,

I have the data say as follows

Dept     

College of Sciences                 

     Physics 

     Chemistry

     Maths

College of Extra Studies          (Chairman College of Extra Studies )

     Physical Studies

     Life Sciences

     English

          English 1

          English 2

     Spanish

          Spanish 1

     Arabic

I have a requirement that if a student is in Physics , Chemistry, Maths -> His Chairman/Manager is Chairman Physics, Chairman Chemistry, Chairman Maths and So on.

and if a student is in  English1, English2,, Spanish 1 etc  -> His chairman is  Chairman English, Chairman Spanish

the sub departments below a depatment is variable ; for eg: English has 2 sub departments and Spanish has 1 sub department