Hello,
I have a word-dictionary database of many languages (Arabic, English, French, Spanish, Hebrew, Russian). Basically, the table "Language" looks like this:
ID | Arabic | English | French | Spanish | Hebrew | Russian
ID is the primary key.
So, each row contains a word translated into these languages.
At one instance, users would only use ONE language at a time, and NO ONE will use two languages at the same time (or it might just rarely happen).
So, I thought that splitting the table into tables would be more effecient. They'd be like this:
AID | Arabic
EID | English
SID | Spanish
.
.
.
etc
Is there a convencing reason for which scheme I should use?
Note that I do not care much about the storage space, as much as concerning about the optimality of the database, since it's going to be very large!
I hope to hear from you.
