Click here to Skip to main content
15,885,546 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
If you have ever downloaded "pleco", that is what i want to program. But, i want to make a multi language version. I want to add Japanese and Korean. I want the same features like the dictionary tab, have it divide the characters to show individual meanings, words that contain that character, and example sentences. I also want to add a synonym and antonym tab.

But I don't know how to go about making the database to store every character and synonyms, sentences, etc.

What I have tried:

I have searched online and came across this type of dictionary:

----------------------------------------------------------------------

class StudentName
{
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public int ID { get; set; }
}

class CollInit
{
    Dictionary<int, StudentName> students = new Dictionary<int, StudentName>()
    {
        { 111, new StudentName {FirstName="Sachin", LastName="Karnik", ID=211}},
        { 112, new StudentName {FirstName="Dina", LastName="Salimzianova", ID=317}},
        { 113, new StudentName {FirstName="Andy", LastName="Ruth", ID=198}}
    };
}

----------------------------------------------------------------------------------

however, this doesn't seem to fit my need for matching language word translations, sentences, etc.

Any suggestions on how to organize this type of data base? show me visual example please.

(This is going to be programmed for android)
Posted
Updated 7-May-18 15:36pm
v2

1 solution

I would probably have a table for each language.
I would then have a many to many link table so you can link words between languages.
I would have a link type table to define the types - direct, antonym, synonym etc.
You might consider a weightage on the link instead to gauge the accuracy of the connection. Negative = antonym, positive = synonym, zero is a direct link.

The above is a very simplistic and rigid design, there should be more flexibly methods of doing something like this.
 
Share this answer
 
Comments
Member 13816219 7-May-18 22:11pm    
can you make an example?
Member 13816219 7-May-18 22:16pm    
挺:very;to straighten
蛮:very
好:good

蛮好看啊!very good!(蛮 and 好 both link to this sentence)
but 挺 蛮 link as synonyms.

and how would i link 挺to the two meanings?
Mycroft Holmes 7-May-18 22:16pm    
Your joking right, that is a very simple database structure.
Member 13816219 7-May-18 22:19pm    
i am new to programming.....
Member 13816219 7-May-18 22:20pm    
I know only how to do a simple thing like what i showed above and display things on the screen, and a calculator.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900