Understanding Attention Mechanism in Transformer Models: A Comprehensive Guide for NLP Applications