|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
SUMMARY:
I have many similar tables that should all be related to each other through many to many relationships, and I am not sure what the best way to do this is. I am currently considering storing all the relationships in a central 'convergence' table. I am not certain this is the best way. Any advice would be appreciated. DETAILS: I am working on a database for a multi-lingual bible study tool. In order for the cross-language implementation to work, words in the English (and other - Chinese at the moment) need to be related to the greek (or hebrew) word(s) they from which they are translated, as well as to each other. This lets me produce an 'interlinear' form: ie (using greek transliterations en: me and you gk: ego kai su For this reason (and in order to link them to definitions) words are stored individually in the database. At the moment, because it is cleaner and because I may add more languages/versions later, I am keeping each version/language in it's own table. Conceptually most words in every version should connect to 1 or more words in any other version. For two tables this is no problem and I use a standard many to many construct: english: enID*, word greek: gkID*, word en_gk_relation: {enID(fk), gkID(fk)}* However when I start getting more tables, it becomes more complex:
One final problem I have is that sometimes there is simply no match for a greek word in the english (or vice-versa). In the reference table this effectively produces a NULL value, which violates the primary key. I can circumvent the error (put a 0), but that's not really any better from a functional standpoint. In these cases, I would still like to include the missing word in as near the right order as possible (after the previous greek word, or before the next, according to the greek order). However with a NULL or a substitute value, it is rather difficult to get any closer than inside the right verse... Thanks for your help and opinions. siri |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > design problem: relationship convergence |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|