No, the word Steve's is the possessive form of the proper noun Steve, the name of a specific person.
The apostrophe s ('s) added to the end of the proper noun indicates that something in the sentence belongs to Steve.
A common noun is a general word for any person, place, or thing.
Examples:
This is Steve's bicycle.
Steve is my brother.
Rick Steves's birth name is Richard Steves.
Anne and Rick Steves divorced in March 2010.
Rick Steves is 6'.
It's a same Steves.
Harold Steves was born in 1937.
Common noun
common
Pea is a common noun, and peas is the plural...still a common noun.
A common noun.
Most definitely a common noun.
Camel is a common noun.
Th word tail is a common noun because the first letter of a proper noun is capitalized.