7. Applying the Principles for Attributes
Chapter Outline
7.1 Looking for Attributes Representing Relationships 79
7.1.1 An Example—Sales Product 80
7.1.2 An Example— Personnel and Security 82
7.2 Identifiers 84
7.2.1 Internal Identification 84
7.2.2 An Example of Inappropriate Choice of Unique Identifier—Ship 85
7.2.3 External Identification 87
7.3 What Other Attributes Might You Expect? 88
7.4 Concluding Remarks on Attributes 88
In this chapter, I look at some practical examples of problems that arise with attributes in data models and how the principles set out in the previous chapter can help overcome or avoid these problems, because they lead to data models that are more stable and regular ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial