Should I Kill Alfred Bloodborne?

Should you cooperate with Alfred in bloodborne?

.

Why did Alfred kill himself bloodborne?

What happens if I swear oath to the Vilebloods?

Where does Alfred go after killing the queen?