What is a goddess?

The noun 'goddess' is a common noun as a general term for any female deity or any female person to which excessive attention is given (He treats her like a goddess.)

The noun 'Goddess' is a proper noun as a Word for a specific female deity (the Goddess Athena).