Hi!
I'm trying to make a dictionary.
WordEng(#id,word);
WordIta(#id, word);
tables with words in Italian and English.
Connect1(#id,id1,id2); connecting word form Eng with Ita translation.
Connect2(#id,id1,id2); same for Italian.
Is this correct? 3. normalisation? Will this work?is this a 1 to 1 relationship? i do not think so. one word can have multiple meanings and that means your design is not right.|||1:N relationship
In III and IV table I store all different translations.
1,A,B
2,A,C
3,D,B|||Hi,
There is a Data Model on the Database Answers web site that might give you some ideas :-
http://www.databaseanswers.org/data_models/dictionaries_for_foreign_languages/index.htm
HTH
B.Dimple
Senior DBA|||thank you.
I will look those db models|||also, please don't put a hash character '#' in your column names. that's non-standard.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment