8. General Principles for Relationships
Chapter Outline
8.1 Example of Inappropriate Cardinalities—Batch and Product Type 89
8.2 Example of Inappropriate Cardinalities—Packed Products 91
8.3 An Example of Inappropriate Cardinalities—Ship 92
8.4 A Good Example of Applying the Principles for Relationships—Transfer and Storage 93
8.5 Concluding Remarks 94
In this chapter I give some examples of the traps found with relationship types in data models, and I show how you can apply the general principles from Chapter 6 to help resolve and avoid these issues. Applying the principles will make your data models more consistent, and they will be more likely to support the data you need, rather than just the data you first thought ...

Get Developing High Quality Data Models now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.