The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling

Silverston c07.tex V2 - 11/20/2008 5:44pm Page 339

Level 2 Contact Mechanism Pattern 339

Table 7-7 ORDER, Telecommunications Numbers and Contact Mechanism Purposes

ORDER. ORDER. ORDER TELECOMMUNICATIONS CONTACT CONTACT

ORDER ORDER NUMBER.COUNTRY TELEPHONE MECHANISM MECHANISM

ID DESCRIPTION CODE, AREA CODE, TYPE. NAME PURPOSE TYPE.

TELEPHONE NUMBER

4

NAME

47742 Cement 1 917 555 2100 Telephone

number

Payment

follow up

47742 Cement 1 917 555 2100 Telephone

number

Shipping

instruction

inquiries

47742 Cement 1 917 555 2100 Fax number Shipment

notification

47790 Steel girders 11 805 555 8999 Telephone

number

Payment

follow up

47799 Gold electrical

wiring

44 20 5555 1234 Mobile

number

Shipping

instruction

inquiries

and not in Table 7-7; however, to set the scene we are just giving you some

background information). There is a telecommunications number of ‘‘1 917

555 2100’’ that is associated with this order t hat ABC Building Corporation

requires just in case it needs to follow up regarding payment for the order or

to call if any shipping problems arise. The third row shows that this number is

also used as a ‘‘Fax Number’’ for ‘‘Shipment notification,’’ or in other words,

to notify the party about the shipment details when the shipment occurs for

the order. According to t he pattern in Figure 7-5, there are two instances of

the ORDER TELECOMMUNICATIONS NUMBER entity, because this number

may be either a ‘‘Telephone number’’