Ok I will explain it from start.
I am working on a completely multilingual website.
Now at this point I am working on Database end.
As this is a multilingual website so I need the Language Table as show below.
--------------------------------
Language
--------------------------------
Id
RomanName
NativeName
Direction
IsVisible
--------------------------------
Next.
I have Book Table.
--------------------------------
Book
--------------------------------
Id
RomanName
NativeName
IsVisible
--------------------------------
Every thing is fine till here.
But I have a limited type of Books and each book is avalaible in different languages.
For Example I add a book translated in Arabic, Urdu and English.
These three books have different ID. But these are the translation of Same book.
And when I have this Book in Urdu By default. And need all the available languages for this book then problem occurs.
To resovle this issue I modify the Book Table and break it into 2 Tables.
--------------------------------
Book
--------------------------------
Id
RomanName
IsVisible
--------------------------------
--------------------------------
BookNative
--------------------------------
BookId
LanguageId
NativeName
--------------------------------
Then an ID will assign for the book and all available language editions have not the ID.
At this end the above mentioned goal will got.
But I explain it on another post
http://forums.asp.net/t/1145293.aspx
And they replied its not correct.
Then again I think it for some time.
And another solution will come in mind.
That make a single Table for Book
--------------------------------
Book
--------------------------------
Id
Name
IsVisible
BookGroupID
--------------------------------
And for the above mentioned goal make a separate BookGroup Table
--------------------------------
BookGroup
--------------------------------
Id
Name
IsVisible
--------------------------------
After this solution Book Table is alone.
Hope you will pick it.
And reply me with some great idea.
Waiting for your reply.
Multilingual Tables
