Principles of Data Management

Introduction

• 1. The purpose of applying a data naming standard to the naming of all data objects (entity types, attributes, domains and relationships in conceptual data models, and tables and columns in the logical schemas for SQL databases) is to ensure that all data objects have consistent, unique and meaningful names.

• 2. The parts of this data naming standard are:

  1. concepts used in naming (paragraphs 3 to 13);

  2. the naming of entity types in a conceptual data model (paragraphs 14 to 21);

  3. the naming of domains in a conceptual data model (paragraphs 22 to 25);

  4. the naming of attributes in a conceptual data model (paragraphs 26 to 30);

  5. the naming of relationships in a conceptual data model (paragraphs 31 to 33);

  6. the naming of tables in an SQL logical ...