I want to calculate all the tag synonyms possible for any given tag.
TagSynonyms table gives the relation between Tag1 -> Tag1Master.
As per TagSynonyms table, Master tag can be mapped to multiple source tags.
I have the following questions in order to calculate all (Direct relationship to master + all the tags using transitivity) the synonyms for a given Tag1:
a) Can any SourceTage have multiple master tags? My guess is no.
b) Can master tag appear as a SourceTag?
c) Does TagSynonyms table contain tags from all the StackExchanges (ie. Android.StackExchange, Security.StackExchange, etc.)?