This base perfume essence would actually not be that attractive by itself and in some cases would be actually unpleasant. It is too concentrated, so it needs to be diluted and this is done with alcohol and water.
Fragrances come in many forms and have many different names but generally the main four categories are as follows:
Perfume: The perfume you see in the store is not the pure perfume essence and has been diluted. However it is the most concentrated of all the fragrance options and it is the most expensive for this reason. It tends to be slightly oilier and will typically contain 15-40% pure perfume extract. It has a slightly thicker, oilier consistency. It tends to be sold with 'stopper bottles' and not sprays. It is too strong to spray all over (and too expensive).
The percentage of pure perfume extract is not necessarily an indicator of the quality of perfume though. As mentioned there are many essential oils that you wouldn't want to smell like in small doses (spikenard comes to mind). Real musk and ambergris are expensive and not pleasant in their pure form, so whereas a single drop can dramatically increase the price of a perfume, but you wouldn't want more than that single drop, which would be sublime.
Eau de Perfume/(Parfum): This uses the same perfume essence but less of it and more alcohol and water. This means the smell is a bit lighter and usually doesn't last quite as long, but as it is a bit lighter, many find this preferable. It is of course cheaper. Typically there will be 10-20% perfume essence in Eau de Perfume. This perfume might be sold in normal bottles or sprays, but if a spray is used, it shouldn't be just doused all over.
Eau de Toilette: This is lighter still and usually sold in spray bottles. The lightness of it makes it more suitable to spray more liberally, the high alcohol content means it will not last very long. Generally this version is the most advisable to use day to day as it is less intense and even if you do use too much it will lighten up fairly quickly. Typically there will be 4-15% pure perfume essence.
Eau de Cologne: Cologne is an abbreviation of 'eau de Cologne' and is the French word for the city of Köln where a particular scent was first made hence it was a water from Cologne. There are specific blends of fragrances that fall in this particular category of 'eau de cologne', they are very light, fresh and fruity and contain the essential oils, lemon, bergamot, orange and also the absolute neroli. They may also contain the essential oils lavender and rosemary.
These days though, eau de cologne or cologne is also used to determine the most diluted version of the perfume. Typically 2-5%. These are rarely used in expensive perfumes, but tend to be more 'splash' kind of perfumes or fragrances for younger people.
NB: The percentages I have given for perfume essence compared to total product are just guidelines. There are no universally agreed ratios and they will vary from source to source.