Sketch startup led

Arduino is powered by computer via usb.Relay has its own unit and no relation with arduino.The relay unit just turns on the computer.

Soooo, the arduino is being powered by the same computer you want to turn on and off?

Off, I can understand, but if the computer is OFF then how will it turn back ON if the arduino has no power?