What is the name given for the number of columns in a table?

Asked

Viewed 517 times

9

What is the name given for the number of columns in a table?

And the name for the number of lines?

mysql sql database terminology
  • 2

    Column is considered attribute and row is considered record.

  • Depends @Everson there are models where each line can be considered an attribute :)

1 answer

12


The number of columns is aridity and the number of lines is cardinality.

Source.

Column, term widely used in SQL, is popularly known as field and academically as attribute.

Row, term widely used in SQL, is popularly known as registry and academically as tuple.

Some sources give slightly more specific definitions for each.

  • 2

    To contribute a little, in this Book on page 52 talks a little about this.

  • @Everson great, take credit for you.

  • Although I also call it that, I think we should be careful with this nomenclature because of modelling similar to this: https://i.stack.Imgur.com/2lE3I.png. Where each row becomes an attribute of the same record.

Browser other questions tagged mysql sql database terminology

You are not signed in. Login or sign up in order to post.