What is the name of the row in the relational data table

This article mainly introduces what the row name is in the relational data table, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

In a two-dimensional table, horizontal rows are called tuples, and each row is a tuple; a tuple corresponds to a specific record in the table.

Data tuples are also called records. Each record in a data table has a unique number (record number). A record is a row in a data table.

Tuple is a basic concept in a relational database. A relationship is a table. Each row in the table (that is, each record in the database) is a tuple, and each column is an attribute. In a two-dimensional table, tuples are also called rows.

Data table structure

The data table consists of three parts: the table name, the fields in the table, and the record of the table. The design of the data table structure is to define the data table file name, determine which fields the data table contains, the field name, field type, and width of each field, and input these data into the computer.

Design the structure of the table:

1. Determine the table name. To ensure the uniqueness of the table name, the name of the table should be consistent with the purpose, concise, intuitive and meaningful.

2. Determine the field name.

The ⑴ field name is less than 64 characters long.

⑵ field names can include letters, Chinese characters, numbers, spaces, and other characters.

The ⑶ field name cannot include a period (.) , exclamation point (!), square brackets ([]), and accent (,).

The ⑷ field name cannot start with a leading space.

3. Determine the field type. Access provides 10 data types to meet the different needs of fields.

4. Determine the field properties. Such as field size, format, default values, required fields, validity rules, validity text, and indexes.

5. determine the only primary key field in the table that can identify the record, that is, the primary key.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share what the row title in the relational data table is. At the same time, I also hope you can support us, pay attention to the industry information channel, and find out if you have any problems. detailed solutions are waiting for you to learn!