Because dogs and cats are pack animals, so in a pack situation, which this is, one animal will make itself dominant. The leader of the pack in your family is one of the cats, and the other cat(s) will be next in line, so the dog comes last. He may not be 'scared' of them as such, just aware of his position in the order or things.