Language assets information model diagram description

The following diagram depicts the language asset information model.

Alternative language
When information is not available in the one of the supported languages the store tries to display the information in an alternative language, if it is available. An alternative language is always part of one store, or store entity, meaning that a store can have zero or more alternative languages.
Supported language
The STORELANG table indicates the languages that each store supports. A store must be able to display information in its supported languages, or one of their alternative languages. A supported language is always part of one store, or store entity, meaning that a store can have zero or more supported languages.
Default language
A default language is associated with each store. This language is the language that the store chooses to use as its main language. This language is the language that displays to customers that do not explicitly choose a shopping language. A default language is specific to a store and thus, the default language is shown as dependent on the Store.
Shopping language
The shopping language is the language that is used in pages that display to a particular customer. If the customer's preferred language is supported by the store or site, then the preferred language is used as the shopping language. Otherwise, the shopping language is the default language for the store or site. There can be only a single shopping language per customer and thus, the shopping language is shown as dependent on the language that the store supports.