Sunday, February 12, 2012

Beginner & DB creating

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.

No comments:

Post a Comment