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

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

Level 1 Contact Mechanism Pattern 313

NOTE

Though ORDER(s) are defined as ‘‘a commitment to purchase goods or

services,’’ there are many different types of orders, such as sales orders (where the

customer orders goods and/or services from the enterprise), purchase orders

(where the enterprise orders goods and/or services from a supplier), or work

orders (where a part of the enterprise orders work to be performed). In this

chapter, the examples given are sales orders where customers are ordering from

the enterprise (ABC B uilding Corporation); however, all of the contact mechanism

patterns would work for any of these types of orders as well. Please see Chapter 4

on ‘‘Ordering Products’’ in The Data Model Resource Book, Volume 1, Revised

Edition ( Wiley, 2001) for more information on subtypes of Orders.

Based on detailed analysis and interviews with management and secretarial

staff, the data professional identified the primary contact address, personal

telephone number, business phone number, and business email addresses

for the different people and organizations with which the company does

business. The data professional also discovered that the company captures

domestic and international phone numbers. Therefore, the data professional

added personal country telephone code and business country telephone

code for the telephone numbers to accommodate ...