Database Answers Skiing near Basel, Switzerland.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Dictionaries for Foreign Languages
Back to the Data Model
The Requirement is a Database to support a Foreign Language Dictionary.
Requirements were defined by the User as follows :-
Subject : Relationship model for English-German dictionary
Question: I am looking for an optimal solution for data model for a dictionary. 

At first dictionary will have only 2 languages: English and German, 
but there should be possibility to add more languages (Finnish, Swedish, Amharic). 

My problem is that there is easily coming many to many relationships and the structure of database will be blurred. 

For instance English words for car: 
1. car
2. automobile 

and in German: 
1. der auto, 
2. der mobile 

What kind of data model structure would be most optimal for this kind of basic dictionary database ?

B. Things of Interest :-
B.1 Languages
B.2 Synonyms
B.3 Words

C. How are they related ?
C.1 A Word can translate into one or many Words in another Language.


Barry Williams
4th. July 2004
Principal Consultant
Database Answers

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map