Ideas for database structure / Dictionary

[eluser]Michael Wales[/eluser]
rather than make a table for each new relation, you could always make a field in the English table (ie. let's name it german_id) that would be used as a key to point to the german equivalent words. Maybe a comma-delimited list.

Either way, you have the basic gist of it down.