Dictionary database and call query

Discussion in 'Databases' started by mirkoxxl, Dec 8, 2013.

  1. #1
    I have created database like this:

    [​IMG]

    I have inside my database about 20 languages and around 3mil translations.

    What is the best query to call list of translations for one word in particular languages to another?

    And can someone explain me this:

    I have for exp this base:

    LANGUAGE
    LANGUAGE_ID | LANGUAGE_NAME
    1|'english'
    2|'german'
    3|'spain'
    
    WORD
    WORD_ID | LANGUAGE_ID | WORD_TEXT
    1|'1'|'house'
    2|'1'|'home'
    3|'2'|'haus'
    4|'3'|'casa'
    
    TRANSLATION
    WORD_ID1 | WORD_ID2
    1|3
    3|1
    1|4
    4|1
    2|3
    3|2
    2|4
    4|2
    4|3
    3|4
    Code (markup):

    And someone want to translate word 'home' to German what query I must do?
    Is this good database for dictionary?
     
    mirkoxxl, Dec 8, 2013 IP