Designing database for Multilanguage dictionary

1
votes

I want to make a database for English to Myanmar multi-ethnics dictionary.

Currently,I have 4 English to Myanmar Ethnic dictionary data for English to Myanmar/Burma Languages.

Example:

English#WordTyp#Transalation#Eg_Sentences#Synonyms

Love #(n)# translation # Language 1 #Eg_Sentences#Synonyms

Love #(v)# translation # Language 2 #Eg_Sentences#Synonyms

Love #(v)# translation # Language 3 #Eg_Sentences#Synonyms

Love #(n)# translation # Language 4 #Eg_Sentences#Synonyms

"WordType" can be "verb", "noun" , "adverb", etc...

Here is example data entries

http://i.imgur.com/hbE60Vm.png

I am not good in Database design, I am thinking about to create "6" tables:

  • English_Word
  • PartOfSpeech
  • Translation
  • Language
  • Synonyms
  • Example_Sentences

in near future, I want to add more Myanmar/Burma ethnic languages.

One English word can have many word type(noun,verb,adverb,..) and can be translated(just a strings) into many languages.

But how is the relations between them? Here is my first database schema.

Could you give me feedback on my draft database table design? my draft database table design

Many thanks in advance. regards,

1
mysqldatabasedictionary

1 Answers

1
votes

id Should be a auto increment field and we can treat all words (in all languages as words )

  WORD (ID,NAME,LANGUAGE_ID,TYPE_ID) //TYPE_ID AND LANG_ID ARE FOREIGN KEYS
TYPE (ID,NAME) // PART OF SPEACH
LANGUAGE (ID,NAME)
SENTENSE (ID, EXAMPLE)
SYNONUMS (ID,WORD_ID,SYNONYM_ID) //TYPE_ID AND SYNONYM_ID ARE FOREIGN KEYS TO WORD TABLE (SYNONYM IS ALSO A WORD)
DICTIONARY (WORD_ID,TRANSLATION_ID, SENTENSE_ID) // TRANSLATION IS ALSO A WORD


LANGUAGE 

id     name
1      english
2      tamil
3      gggggg

TYPE
ID    NAME
1     NOUN
2     MMMMM

WORD
ID  NAME LANGUAGE_ID TYPE_ID
1   LOVE    1          1
2   $#%#$%  2          1
3   PASSION 1          1
4   HHJHJHJ 1          2

SENTENCE 
ID   EXAMPLE
1 HAFKAKJDHAKJFHAHLFALFLASLDAL

SYNONUMS

ID   WORD_ID     SYNONYM_ID
1      1             3       //LOVE =>SYNONUMS PASSION
2      1             4

DICTIONARY
WORD_ID   TRANSLATION_ID   SENTENSE_ID
1              2               1         //LOVE $#%#$% HAFKAKJDHAKJFHAHLFALFLASLDAL