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