remeber RED CAT, so reduction occurs at teh cathode. This means that an ion is gaining electrons and depending on the ion in question may stay in solution but lower in oxidisation number, be reduced to a solid which forms on the cathode itself, or be reduce to a gas which floats away into oblivion. To detirmine what occurs you must analyse the potential candidates for reduction, generally these are either cations or the water itself. some cations like Na+ are never reduced in aqueous solution as water has a greater reduction potential. However some ions such as Cu+ will always be reduced with priority over water as they have a greater reduction potential. For ions witha similar reduction potential to water, they will only be reduced if they are in sufficient concentration.
O yeah and if you're not sure waht reduction potential is, it is simply a mreasure of what is more like ly to be reduced. The standard emf's for the reduction half cells found in your data sheet are reflections of these values. Being a standard REDUCTION table, the greatuer the emf number (further down the page), the more likely that particular ion/molecule is to be reduced. SO say youve got a solution containing sliver ions. look at the table, the reduction of silver ions to silver is waaay further down than the reduction of water, so they are reduced as a solid onto the cathode. HOwer take the example of calcium ions. In this case, water is below the Ca2+ reduction half equation so it takes priority, meaning that water is reduced to form hydrogen gas which bubbles out at the cathode. Howver if we take zinc ions for example, their half equation is right under water's. So they will be reduced only if their concentration is high enough (you dont need to know exactly how high).
hope that helped