The data model resource book, Volume 1: A library of universal data models for all enterprises
A quick and reliable way to build proven databases for core business functionsIndustry experts raved about The Data Model Resource Book when it was first published in March 1997 because it provided a simple, cost-effective way to design databases for core business functions. Len Silverston has now r...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
[Hoboken, N.J.]
John Wiley & Sons
2001
|
| Edition: | Rev. ed |
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Ship-to Party and Contact MechanismBill-to Party and Contact Mechanism; Person Roles for Orders; Purchase Order Parties and Contact Mechanisms; Generic Order Roles and Contact Mechanisms; Order Adjustments; Order Status and Terms; Order Status; Order Terms; Order Item Association; Optional Order Models; Requirements; Requirement Roles; Requirement Status; Product Requirements; Order Requirement Commitments; Requirement Example; Requests; Request; Request Items; Quote Definition; Quote Roles; Quote; Quote Items; Quote Terms; Agreement Definition; Agreement Item; Agreement Terms
- Relationship CardinalityForeign Key Relationships; Foreign Key Inheritance; Intersection or Association Entities to Handle Many-to-Many Relationships; Exclusive Arcs; Recursive Relationships; Physical Models; Conventions Used for Illustration Tables; Conventions Used to Reference Figures; The Companion Electronic Product; Chapter 2 People and Organizations; Organization; Person; Person-Alternate Model; Party; Party Roles; Organization Roles; Common Party Role Subtypes; Should Roles Be Defined at the Time of the Transaction?; Party Role Example; Role Types throughout This Book
- The Data Model Resource Book Revised Edition Volume 1; Contents; Foreword; Acknowledgments; About the Author; Chapter 1 Introduction; 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; Entities; Subtypes and Supertypes; Non-Mutually Exclusive Sets of Subtypes; Attributes; Relationships; Relationship Optionality
- Unit of MeasureSuppliers and Manufacturers of Products; Inventory Item Storage; Product Pricing; Pricing Subtypes; Price Component Attributes and Relationship to Product or Product Feature; Pricing Factors; International Pricing; Example of Product Pricing; Product Costing; Product to Product Associations; Products and Parts; Summary; Chapter 4 Ordering Products; Standard Order Model; Order and Order Items; 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
- Party RelationshipParty Relationship Examples; Party Relationship Information; Status Types; Party Contact Information; Postal Address Information; Geographic Boundaries; Party Contact Mechanism-Telecommunications Numbers and Electronic Addresses; Party Contact Mechanism (Expanded); Contact Mechanism Purpose; Facility versus Contact Mechanism; Party Communication Event; Communication Event Follow-Up; Summary; Chapter 3 Products; Product Definition; Product Category; Product Identification Codes; Product Features; Product Feature Interaction; Product Feature Subtypes; Product Feature Examples