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.
That was all the story.
Hope you will pick it.
And reply me with some great idea.
Waiting for your reply.
Multilingual Database Objects
