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 c08.tex V2 - 11/21/2008 3:12am Page 437
SPECIFIC
FACTORS
GENERALIZED
FACTORS
THE SUBJECTS OF THE RULE
GEOGRAPHIC BOUNDARY ID ID (PK)
* NAME CHAR
..............................................
PRICE COMPONENT RULE ID ID (PK)
PRODUCT ID ID (FK)(UID)
PRODUCT FEATURE ID ID (FK)(UID)
GEOGRAPHIC BOUNDARY ID ID (FK)(UID)
ROLE TYPE ID ID (FK)(UID)
PRODUCT CATEGORY ID ID (FK)(UID)
QUANTITY BREAK ID ID (FK)(UID)
ORDER VALUE ID ID (FK)(UID)
PRICE COMPONENT RULE TYPE ID (FK)(UID)
* FROM DATE DATE (UID)
THRU DATE DATE
RULE STATEMENT DESC
RULE NAME CHAR
PRICE AMOUNT MONEY
DISCOUNT AMOUNT MONEY
SURCHARGE AMOUNT MONEY
DISCOUNT PERCENTAGE NUM
SURCHARGE PERCENTAGE NUM
AMOUNT CURRENCY TYPE ID ID (FK)
EFFECTIVE FROM DATE DATE
EFFECTIVE THRU DATE DATE
PRODUCT
GEOGRAPHIC BOUNDARY
PRICE COMPONENT RULE
ATTRIBUTE
OUTCOMES
ATTRIBUTE
FACTORS
RULE
PRODUCT ID ID (PK)
* NAME CHAR
....................................
PRODUCT FEATURE ID ID (PK)
* NAME CHAR
....................................
PRODUCT FEATURE
ROLE TYPE ID ID (PK)
* NAME CHAR
..............................................
ROLE TYPE
PRODUCT CATEGORY ID ID (PK)
* NAME CHAR
..............................................
PRODUCT CATEGORY
priced
by
priced
by
a rule for
a condition for
based on
QUANTITY BREAK ID ID (PK)
* FROM QUANTITY NUM
THRU QUANTITY NUM
...................................
QUANTITY BREAK
ORDER ...