How does aperture affect depth of field in a photograph, and what factors should be considered when choosing an aperture setting for a given scene?

How does aperture affect depth of field in a photograph, and what factors should be considered when choosing an aperture setting for a given scene?