Im building a website that will be translated into 10 different languages. The database contains alot of attrubutes with text such as book title, book review, book description etc etc.

What is the best sollution for this when it comes to designing the database? Will each attribute have "duplicate" attributes for all the different languages?

Example (sorry for my ugly drawing):

_____
|----|----English_book_title
|Book|
|----|----Spanish_book_title
|____|

This Data Model on my Database Answers Web Site shows you a simple example :-
Foreign Language Tournament Listings Data Model

You can see that the Language ID is part of the Primary Key in the Tournaments Details Table, which means that a separate description can be stored for each language.

HTH

Barry Williams
London, England

Thanks alot Barry! Appreciate it!