Welcome Guest, Not a member yet? Register   Sign In
Ideas for database structure / Dictionary
#1

[eluser]trice22[/eluser]
Hello and sorry, if this a bit of a vague topic, but I'm in the early stages of a new project and not really experienced with the development of database structures—so every input would be very welcome.

Here's what I want to do:
I'm planning on a small app. that will work a little like a dictionary. That means I've at least two languages (let's say English and German) and vocabulary for both of them.
That would call for two tables:
Code:
English with ID and word and
German with ID and word

And since one word (like "to put") can have more than one meaning ("setzen", "stellen", legen") I'll need a third table for the relations between table "English" and "German".

Something like
Code:
ID, ID_eng, ID_ger
.
Am I correct so far? Is there a better way to handle something like this?

Now here's my bigger problem:
The amount of languages is dynamic. Let's say, somebody could add French or Chinese.
How would I handle the relations then? If I'd have an extra table for each relation I'll very soon reach a gigantic amount of tables. There gotta be a better way.
Any ideas, links or general input to the dictionary-in-a-database topic?

I'm in the planning stage and very grateful for every idea.
Thanks a lot,
-trice

P.S.: I know this is not necessarily CI related, but since the app. is going to be developed with CI and everyone in here always very helpful, I'm still going to give it a shot.


Messages In This Thread
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 07:22 AM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 07:25 AM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 07:33 AM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 10:25 AM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 10:48 AM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 12:42 PM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 12:52 PM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 01:50 PM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 02:01 PM
Ideas for database structure / Dictionary - by El Forum - 10-11-2007, 03:25 PM



Theme © iAndrew 2016 - Forum software by © MyBB