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

Silverston c03.tex V2 - 11/21/2008 2:59am Page 93

Table 3-5 Example of Level 2 Contextual Role Pattern with PARTY ROLE Subtypes, PARTY, ROLE TYPE, and PARTY ROLE

PARTY. PARTY. ROLE TYPE. ROLE TYPE. PARTY ROLE. PROJECT LEAD. WORKER. SPONSOR.

PARTY ID FIRST NAME, ROLE TYPE ID ROLE TYPE PARTY ROLE LEAD TRAINING WORKER SPONSOR

LAST NAME, NAME NAME ID LEVEL NUMBER RATING

001 Neena Davies 1 Worker 5001 4412

002 Una Corr 1 Worker 5004 4455

002 Una Corr 2 Project Lead 1004 8

003 Paul Lane 1 Worker 5008 4499

004 Vinnie Chintappaly 2 Project Lead 1006 3

005 Master Data Management 3 Sponsor 7002 A++

006 Human Resources Dept. 3 Sponsor 7004 A

007 Yi Lan Tsang 1 Worker 5010 4400

008 Information Technology Dept. 3 Sponsor 7006 B++

009 Steve Toland 1 Worker 5012 4487

010 John Teevan 1 Worker 5014 4445

011 Audit Dept. 3 Sponsor 7008 A++

Silverston c03.tex V2 - 11/21/2008 2:59am Page 94

Table 3-6 Example of Level 2 Contextual Role Pattern with PARTY ROLE Subtypes, PARTY, ROLE TYPE, PROJECT, SPONSOR, and

PROJECT SPONSOR

PROJECT. PROJECT. PROJECT PROJECT PROJECT PARTY ORGANIZATION.

PROJECT ID PROJECT SPONSOR. SPONSOR. SPONSOR. ROLE. NAME

NAME PROJECT SPONSOR ID FROM DATE THRU DATE PARTY ROLE ID (FOR SPONSOR)

1001 Customer Master

Project

100 Oct. 10, 2007 7002 Master Data

Management

1002 Human Resources

Database

200 Feb. 15,