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/21/2008 2:59am Page 104
Table 3-10 Example of Level 2 Contextual Roles, PARTY Only Alternative with PARTY, PROJECT, and PROJECT WORKER
PROJECT. PROJECT. PROJECT PROJECT PROJECT PARTY. PERSON.
PROJECT ID PROJECT WORKER. WORKER. WORKER. PARTY ID FIRST NAME,
NAME PROJECT WORKER ID FROM DATE THRU DATE LAST NAME
1001 Customer Master
Project
101 Oct. 10, 2007 Jan. 18, 2007 001 Neena Davies
1001 Customer Master
Project
102 Feb. 15, 2008 006 Yi Lan Tsang
1002 Human
Resources
Database
103 Jan. 1, 2009 001 Neena Davies
1002 Human
Resources
Database
104 Jan. 28, 2009 Sept. 4, 2009 003 Paul Lane
1003 Information
Architecture
Standards
105 Mar. 10, 2008 002 Una Corr
1003 Information
Architecture
Standards
106 Sept. 5, 2011 009 Steve Toland
1005 Sarbanes-Oxley
Reporting
107 Jan. 3, 2011 003 Paul Lane
1005 Sarbanes-Oxley
Reporting
108 June 11, 2010 0010 John Teevan
Silverston c03.tex V2 - 11/21/2008 2:59am Page 105
Level 2 Contextual Role Pattern, PARTY Only Alternative 105
Table 3-10 contains examples of projects and related contextual roles for
workers on a project. Many people today work on multiple different projects
in their day-to-day jobs. In the following examples you see ‘‘Neena Davies’’
assigned to both the ‘‘Customer Master Project’’ and the ‘‘Human Resources
Database’’ project between Jan 1, 2008 ...