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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Silverston c06.tex V2 - 11/21/2008 3:09am Page 291
Table 6-8 (Continued)
STATUS TYPE STATUS STATUS TYPE STATUS STATUS TYPE STATUS TYPE STATUS TYPE
ASSOCIATION. FROM TYPE. NAME ASSOCIATION. TO TYPE. CATEGORY. ASSOCIATION ASSOCIATION
STATUS TYPE ID (FROM) STATUS TYPE ID NAME (TO) NAME RULE. NAME TYPE. NAME
30 Order
Confirmed
70 Order
Cancelled
Order
Fulfillment
Compatible Peer-to-Peer
Association
70 Order
Cancelled
102 Order Revenue
Recorded
Order
Fulfillment
Exclusion Peer-to-Peer
Association
70 Order
Cancelled
37 Order
Cancelled Due
to
Backordered
Inventory
Order
Fulfillment
Exclusion Aggregation
88 Open Order 10 Order Opened Order
Fulfillment
Obsolescent Peer-to-Peer
Association
77 Cancelled
Purchase
Order
70 Order
Cancelled
Order
Fulfillment
Implied Peer-to-Peer
Association
20 Order Entered 66 Order Inputted Order
Fulfillment
Substitution Peer-to-Peer
Association
Silverston c06.tex V2 - 11/21/2008 3:09am Page 292
292 Chapter 6 ■ Status: The States of Data
must precede the ‘‘Order Confirmed’’ status. The fourth row of this table shows
that ‘‘Order Entered’’ and ‘‘Order Confirmed’’ are also ‘‘Compatible’’ (along
with many other pairs of status types that are also compatible). This means that
the association between ‘‘Order Entered’’ and ‘‘Order Confirmed’’ status types
may exist within the ‘‘Order Fulfillment’’ set of statuses, and thus the
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,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.