Relay turns on when computer is disconected

So when you disconnect the USB cable the Arduino should still be being powered from the mains adaptor and there should be no change. If you are getting a change it means that things are not wired like your diagram says they are.