Timedora

Reading Relational Tables

Learn how relational tables organize records and attributes, and how to read their schema and cells without assuming rows have a fixed order.

Rows, Columns, Cells, and

One subject, organized into records

A relational stores information about one kind of subject. In the Students below, each describes an attribute of a student, and each contains one student's record.

Students
student_idnamebirth_date
1042Maya Chen2007-03-12
1043Luis Romero2006-11-28
The Students table: each row is one student record, and each column names an attribute.

Finding a and understanding the

A is the value where a and a meet. For example, the in Maya Chen's and the birth_date contains 2007-03-12.

The defines the 's columns—here, student_id, name, and birth_date. The rows are the records, and they can vary as data is added or removed; the describes the 's structure rather than its current set of students.

One important point: rows have no guaranteed order. If you need students listed in a particular order, request sorting explicitly instead of assuming the will always display them in the order shown.