From the course: Database Foundations: Intro to Databases
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Table rows
From the course: Database Foundations: Intro to Databases
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.