Table of Contents

Introduction

1. Entities, Properties, Names, and Identifiability

2. Relational Representation

3. Kinds of Keys

3.1. Candidate, Primary, and Alternate Keys

3.2. Natural and Surrogate Keys

4. Primary Formal Mandate

5. Primary Key Designation

6. Primary Keys and Performance

6.1. Indexes

Conclusion

Appendix: Primary Keys, Duplicates and SQL