What are the key differences between system software and application software in modern computing?