Department in respect to language

I have to Make Department Table.

But this there names can be in multi language.

--------------
DepartmentGroup
--------------
DepartmentGroupId (P.K.)
UniqueName
CreatedDate
ModifiedDate
--------------

--------------
Department
--------------
DepartmentId (P.K.)
NativeName
NavigateUrl
IsFavorite
LanguageId (F.K.)
DepartmentGroupId (F.K.)
IsVisible
CreatedDate
ModifiedDate
--------------

From this design we can move to same department in different language.

is it right?

You essentially need a base departments table, a language table, and the department names table.

I'm assuming DepartmentGroup is your base departments table and Department is your department names table. You link the two by the DepartmentGroupId(FK), and you link Department to the Language table using LanguageId (FK).

Looks correct to me.

|||

One more thing, make sure to set your language specific fields to nvarchar instead of varchar so it can hold the special characters.