becuase the idea behind that is to allow the user to translate the text data like employee name to many laguages.
【Solutions】
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。
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Convert (1 to Many ) to (1 to 1) Case
Apr 23, 2012 01:24 AM|LINK
【Solutions】
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。
Reguards！