What is the difference between a do-follow and no-follow and how are they used?

Please describe the relationship between SEO and SEM?