Its primary meaning is a famous female singer, especially an opera singer. This sense has no negative connotation, It can also mean a woman who is haughty and temperamental, and who expects special treatment. In this sense, it does have a negative connotation.