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 c03.tex V2 - 11/20/2008 9:05am Page 112
Table 3-13 Example of Level 3 Contextual Roles, PARTY, ROLE TYPE, PROJECT, and PROJECT ROLE
PROJECT. PROJECT. ROLE TYPE. ROLE TYPE. PROJECT PROJECT PROJECT PARTY.
PROJECT ID PROJECT ROLE TYPE ID NAME ROLE. ROLE. ROLE. FIRST NAME,
NAME FROM DATE THRU DATE PARTY ID LAST NAME, NAME
1001 Customer
Master Project
1 Project Worker Sept. 5, 2009 001 Neena Davies
1001 Customer
Master Project
2 Project Lead Sept. 1, 2009 002 Una Corr
1001 Customer Master
Project
1 Project Worker Sept. 1, 2009 002 Una Corr
1001 Customer Master
Project
3 Project Sponsor June. 1, 2009 005 Master Data
Management
1001 Customer Master
Project
1 Project Worker Oct. 9, 2009 Oct. 9, 2010 006 Yi Lan Tsang
1002 Human Resources
Database
1 Project Worker Mar. 1, 2008 001 Neena Davies
1002 Human Resources
Database
2 Project Lead Mar. 2, 2008 Aug. 1, 2010 002 Una Corr
1002 Human Resources
Database
2 Project Lead Aug. 2, 2009 004 Vinnie Chintappaly
1002 Human Resources
Database
3 Project Sponsor Jan. 1, 2009 006 Human Resources
Dept.
1002 Human Resources
Database
1 Project Worker Feb. 5, 2008 003 Paul Lane
Silverston c03.tex V2 - 11/20/2008 9:05am Page 113
Table 3-13 Example of Level 3 Contextual Roles, PARTY, ROLE TYPE, PROJECT, and PROJECT ROLE
PROJECT. PROJECT. ROLE TYPE. ROLE TYPE. PROJECT PROJECT PROJECT ...