The naming of columns in an SQL logical schema

  • 35. Except in the particular cases described in paragraphs 36 and 37, all columns are named with singular nouns or noun phrases in lower camel case, with the name representing the value recorded at the row–column intersection in the table. The name of the table is not included in the name of the column, but is used with the column name when referring to the column conversationally, for example:

    designation (in EQUIPMENT_TYPE, conversationally EQUIPMENT_TYPE.designation)

    lastServiceDate (in EQUIPMENT, conversationally EQUIPMENT.lastServiceDate)

    isbn (in PUBLICATION, conversationally PUBLICATION.isbn)

  • 36. Columns declared as a single-column primary key of a table using the IDENTITY or AUTONUMBER datatype ...

Get Principles of Data Management 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