Greek Mythology
This theory felt very strong at first. Scorpius and Orion have a direct mythological story, and Cassiopeia is also a famous queen from Greek myths. However, the theme breaks on 'Canis Major' and 'Ursa Minor', as these are Latin terms for 'Great Dog' and 'Little Bear' and aren't primary figures in the same narrative sense as the others.