Why Is There a Need for This Book?
Who Can Benefit from Reading This Book?
The Need for Universal Data Models
A Holistic Approach to Systems Development
What Is the Intent of This Book and These Models?
What Is New in the Second Edition of the Data Model Resource Book?
Conventions and Standards Used in This Book
Non-Mutually Exclusive Sets of Subtypes
Intersection or Association Entities to Handle Many-to-Many Relationships
Conventions Used for Illustration Tables
Conventions Used to Reference Figures
The Companion Electronic Product
Chapter 2 People and Organizations
Should Roles Be Defined at the Time of the Transaction?
Role Types Throughout This Book
Party Relationship Information
Party Contact Mechanism—Telecommunications Numbers and Electronic Addresses
Party Contact Mechanism (Expanded)
Facility Versus Contact Mechanism
Suppliers and Manufacturers of Products
Price Component Attributes and Relationship to Product or Product Feature
Product to Product Associations
Order Parties and Contact Mechanisms
Sales Order Parties and Contact Mechanisms
Party Placing Order and Related Contact Mechanism
Party Taking Order and Related Contact Mechanism
Ship-to Party and Contact Mechanism
Bill-to Party and Contact Mechanism
Purchase Order Parties and Contact Mechanisms
Generic Order Roles and Contact Mechanisms
Shipments Parties and Contact Mechanisms
Shipment-to-Order Relationship
Item Issuance for Outgoing Shipments
Work Requirement and Work Efforts
Work Requirement Compared to Order
Work Effort Type and Work Effort Purpose Type
Fulfillment of Work Requirements
Work Effort Generation—Alternate Model
Work Effort Association Definition
Work Effort Assignment Facility
Fixed Asset Assignment and Status
Work Effort Fixed Asset Standard
Invoice and Associated Transactions
Billing for Work Efforts and Time Entries
Financial Accounts, Deposits, and Withdrawals
Chapter 8 Accounting and Budgeting
Chart of Accounts for Internal Organizations
General Ledger Accounts and Types
Accounting Transactions Definition
Business Transactions versus Accounting Transactions?
Accounting Transactions and Their Related Parties
Accounting Transaction Details
Relationships between Accounting Transaction Details
Account Balances and Transactions
Usage and Sources of Budgeted Amounts
Budget Relationship to General Ledger
Budgeted Items versus General Ledger Accounts
Standard Human Resources Model
Position Fulfillment and Tracking
Position Reporting Relationships
Salary Determination and Pay History
Benefits Definition and Tracking
Employee Skills and Qualifications
Chapter 10 Creating the Data Warehouse Data Model from the Enterprise Data Model
The Data Warehouse Architecture
The Departmental Data Warehouse Design or Data Mart
An Architected Data Warehouse Environment
High-Level and Logical Data Models
Adding an Element of Time to the Warehouse Key
Creating Relationship Artifacts
Organizing Data According to Its Stability
Chapter 11 A Sample Data Warehouse Data Model
Transformation to Customer Invoice
Creating Relationship Artifacts
Accommodating Levels of Granularity
The Sample Data Warehouse Data Model
Chapter 12 Star Schema Designs for Sales Analysis
Customer Demographics Dimensions
Internal Organizations Dimension
Transaction-Oriented Sales Data Mart
Variations on the Sales Analysis Data Mart
Variation 1: Sales Rep Performance Data Mart
Variation 2: Product Analysis Data Mart
Geographic Boundaries Dimension
Chapter 13 Star Schema Designs for Human Resources
Human Resources Star Schema at a Higher Level of Granularization
Chapter 14 Additional Star Schema Designs
Chapter 15 Implementing the Universal Data Models
The Enterprise Data Model—An Integrated Business View of the Enterprise's Information
Customizing the Universal Data Models
Customizing the Models for Unique Business Terminology
Example of Changing the Terms for the Specific Enterprise
Additional Information Requirements Needed for the Enterprise
How the Universal Data Models and Enterprise Data Model Solve Business Problems
Using a Data Model for a Particular Application
Understanding Business Processes
Building the Logical Data Model
Basic Database Design Principles
Creating a Physical Database Design
Physical Database Design Examples
Review of the Party Role and Relationship Model
Party Roles and Relationships Physical Design, Option 1
Party Roles and Relationships Physical Design, Option 2
Party Roles and Relationships Generic Design, Option 3
Using the Data Warehouse Models
Appendix A Logical Data Model Entities and Attributes
Appendix B Data Warehouse Data Model Tables and Columns
Appendix C Star Schema Design Tables and Columns
Other Reusable Data Model and Data Warehouse Design Resources