well 'server' means you want your redhat box to function as a linux server. while 'workstation' is the standard desktop install. (makes it look like windows) the rest of the types speak f/themselves. when i installed redhat, i picked workstation and kde.
there really should be a manual on your cd to learn more, redhat's site should also have a manual for dl. better get it while they still support the product.