Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 23, 2012 01:24 AM by Decker Dong - MSFT
Apr 23, 2012 01:24 AM|LINK
becuase the idea behind that is to allow the user to translate the text data like employee name to many laguages.
Employee(Id,Name,Salary)：Here only for Employees……
Language(Id,LanguageName)：Here's only for Languages……
Translations(Id,EmployeeId,LauguageId)：Here's a joint table for Employee and Language……In my mind，You should create a Many-To-Many relationship between the two tables，because One Employee can have multiple languages，and so you can find out all the languages
belonging to a certain Employee……And if one employee can only learn one language，you can find only one——for "One" is a special thing for Many。