title: How do I structure a Cross Referenceble Multi Language Dictionary Database?
body: <p>This database should support three way-cross referencing between Mongolian, English, an Chinese, as well as stand as a dictionary of its own for each language.</p>
  
  <p>The information encoded for <strong>English</strong> would include things like: Word, IPA pronunciation (s), definition(s), example sentence(s), plural spelling, plural pronunciation, synonyms, antonyms, word type, study note(s), Chinese equivalent(s), Mongolian C. equivalent(s), Mongolian S. equivalent(s)</p>
  
  <p><strong>Chinese</strong>: Traditional character, Simplified character, definition(s), pinyin pronunciation(s), example sentence(s), synonyms, antonyms, HSK test level, strokes, radical(s), lookup radical,  collocating measure words, word type,  simple explanation of character,  in depth explanation of character, study note(s), English equivalent(s), Mongolian C. equivalent(s), Mongolian S. equivalent(s)</p>
  
  <p><strong>Mongolian Cyrillic</strong>: Cyrillic word, Cyrillic definition, Cyrillic definition(s), Cyrillic examples, c. synonyms, c. antonyms, Chinese equivalents, Inner Mongolian (script) equivalent meaning, Mongolians script equivalent spelling,Eng. Equiv.(s), Chin. Eqiv.(s)</p>
  
  <p><strong>Mongolian script</strong>: script, script alternative ending, script definition(s), script definition(s), s. synonyms, s. antonyms word type(s), study note(s), Eng. Equiv.(s), Chin. Eqiv.(s), Outer Mongolian (Cyrillic) equivalent meaning(s), Mongolian Cyrillic equivalent spelling.</p>
  
  <p>I'm very new with databases. At first I considered making a table for each language, but this leaves a problem with all plural (s) items.
  Now I wonder if I need a table for each item of each language in order to ensure I don't wind up not being able to include all the information I need. I was thinking, for each entry the link between languages would be base on it's ID/PK. </p>
  
  <ol>
  <li>Do I have the right idea with the database?</li>
  <li>If I want to include this much information, then each item that may include multiple values needs its own table, no?</li>
  <li>But, it's true that editing this should be easy, provided each is linked by it's PK, I can edit all values from a language (or cross language) from one interface, right?</li>
  <li>What about the issue of not knowing how many multiple entries there may be. For instance, some words may have more equivalents, or more same language synonyms than others. Is this an issue, or do you just add more columns in the table, no problem?</li>
  </ol>