Hi everybody!

I would like do design a database (MySQL) for a website that needs to
be presented in 10 different languages, including English, Chinese,
Russian and Arabic.

For example, im going to have a "products" table, with fields id,
name, price and description.

I have another table "languages", with id, name, regional_name, and
iso6391.

Which is the best way of modelling this?

I thought about splitting the fields from "products" that need to be
internationalized in separate tables, or adding a third table
"languages_products", that joins each record from products with a
language.

Im sure you might know better approaches to this, so i would be
pleased to hear them.

Thank you very much!