From the course: Database Foundations: Intro to Databases

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Table rows

Table rows

- [Instructor] In a table, if columns make up the attributes about the data, then each row represents the individual items that the table is storing information about. To find out information about a single entity, you need to read across all of the columns in the table. For instance, in this table about pets, Brie, the ferret, is three years old. It's important to understand that the order that the rows appear in the table is irrelevant. The fact that Brie, the ferret, appears at the top of the table has no real-world significance. It doesn't mean that Brie is better than Wensleydale the cat, or older, or was even entered into the database first. Rows can appear in any order at any time. So avoid the temptation to try and give the sorting of the rows a special meaning. Right now, the rows are sorted in this view, numerically based off of the PetID number. So the only thing that you can say about the order of the rows…

Contents