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 85
Table 3-2 Example of Level 1 Contextual Roles, Project, Sponsor, and Project Sponsor
PROJECT. PROJECT. PROJECT PROJECT PROJECT SPONSOR. SPONSOR.
PROJECT ID PROJECT SPONSOR. SPONSOR. SPONSOR. SPONSOR ID SPONSOR
NAME PROJECT FROM THRU NAME
SPONSOR ID DATE DATE
1001 Customer
Master Project
100 Oct. 10, 2007 005 Master Data
Management
1002 Human
Resources
Database
200 Feb. 15, 2008 006 Human Re-
sources Dept.
1003 Information
Architecture
Standards
300 Jan. 1, 2009 008 Information
Technology
Dept.
1005 Sarbanes-Oxley
Reporting
400 Jan. 28, 2009 Sept. 4, 2009 008 Information
Technology
Dept.
1005 Sarbanes-Oxley
Reporting
500 Mar. 10, 2008 0011 Audit Dept.
85
Silverston c03.tex V2 - 11/21/2008 2:59am Page 86
Table 3-3 Example of Level 1 Contextual Roles, Project, Project Worker, and Worker
PROJECT. PROJECT. PROJECT WORKER. PROJECT PROJECT WORKER. WORKER.
PROJECT ID PROJECT PROJECT WORKER. WORKER. WORKER ID WORKER FIRST NAME,
NAME WORKER ID FROM DATE THRU DATE WORKER LAST NAME
1001 Customer
Master Project
101 Oct. 10, 2007 Jan. 18, 2009 001 Neena Davies
1001 Customer
Master Project
102 Feb. 15, 2008 007 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 ...