January 2009
Beginner to intermediate
641 pages
26h 48m
English
book
The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling
by Paul Agnew, Len Silverston
Content preview from The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Silverston c07.tex V2 - 11/20/2008 5:44pm Page 318
Table 7-2 ORDER Contact Mechanisms, Ship to Address, Bill to Address, Phone Number, and Email
ORDER. ORDER. ORDER.SHIP ORDER.SHIP TO CITY, ORDER.BILL ORDER.BILL TO CITY, ORDER.TELEPHONE ORDER.
ORDER ORDER TO ADDRESS SHIP TO STATE-REGION,
3
TO ADDRESS BILL TO STATE-REGION,
3
NUMBER (COUNTRY EMAIL
ID DESCRIPTION PART1,2,3
4
SHIP TO COUNTRY, PART 1, 2, 3
4
BILL TO COUNTRY, TELEPHONE CODE, ADDRESS
SHIP TO POSTAL CODE
4
BILL TO POSTAL CODE
4
AREA CODE,
TELEPHONE NUMBER)
4
47742 Cement 100 Main
Street, Suite
819, The
Coalman
Building
New York, NY,
USA, 10019
100 Main
Street, Suite
819, The
Coalman
Building
New York, NY,
USA, 10019
1 917 555 2100 Info@
XYZ.com
47790 Steel girders 55 Right Road,
The Foundry
Los Angeles, CA,
USA, 90210
100 Boulder St,
Suite 23
Santa Monica, CA,
USA, 90212
11 805 555 8999
47799 Gold electrical
wiring
Andheri Kurla
Road, no. 604,
Marol
Mumbai, Andheri East,
India, 400099
55 Charing
Cross Road,
Suite 233,
Shaldon
Mansions
London, UK, WC2H 0LA 44 20 5555 1234 Mcollet@
mtln.
net.in
Silverston c07.tex V2 - 11/20/2008 5:44pm Page 319
Level 1 Contact Mechanism Pattern 319
is responsible for the logistics for an order, but may not care about the billing
issues. The accounting staff is required to pay the bills; therefore, the ‘Bill to’
address is crucial to them. This raises ...