I can only try to help regarding the answer for your last question -
"Also, If the center console window switch controlling a rear window is not functioning, will this affect the functionality of the rear seat window switch for the same window? "
No - it should not. Unless the faulty switch is removed completely.