Rottweiler vs sheep dog

Rottweiler and sheep dog both are nouns.

Word	Noun	Adjective	Verb	Adverb
Rottweiler	Yes	No	No	No
sheep dog	Yes	No	No	No

As nouns, sheep dog is a hypernym of Rottweiler; that is, sheep dog is a word with a broader meaning than Rottweiler:

Rottweiler: German breed of large vigorous short-haired cattle dogs
sheep dog: any of various usually long-haired breeds of dog reared to herd and guard sheep

Other hypernyms of Rottweiler include sheepdog, shepherd dog.

Rottweiler (noun)	sheep dog (noun)
German breed of large vigorous short-haired cattle dogs	any of various usually long-haired breeds of dog reared to herd and guard sheep