Databases Reference
In-Depth Information
− The attributes of the
Address
class do not have
functional data dependency. Each address is linked to a
City
,
the attachment of which to the
Territory Office
and
Territory
permits the automatic calculation of its postal code,
via
the
derived attribute “
/postal code
” of the
Postal Code
class.
− The
Territory Office
is, for example, the postal office for
France or the postal zone for the United States.
− In France, the
Territory Office
code consists of three
numbers. For example, the town of Orléans has two postal
offices: the first for the North of the town (000), and the
second for the South (100).
− By prefixing these codes with the
Territory
code (in
French: département) it is possible to obtain the postal codes
(45 000 and 45 100). For the big cities, these correspond to
districts (in French: arrondissements).
In the United States, the
Territory Office
consists of two
numbers.
In other countries, the
Territory Office
can be organized
differently. For instance, in England, it consists of the
concatenation of the postal zone, the district zone, the sector
and finally the unit. The reflective association “
divides in
” on
the
Territory Office
class enables an expression of this
decomposition.
− The values of the
Type of Territory Office
class
enumeration depend on the country, for example: postal code
for France, postal zone for the US, postal zone, district zone,
sector
and
unit for England, etc. The
pattern
attribute
enables the declaration of the input format that should be
respected, depending on the
Type of Territory Office
.