3. Columns and rows


Tables in databases look just like ordinary data tables – they have columns and rows.

Each column of a table has a meaningful name denoting the type of information it stores.

Each row of a table stores information about one particular object belonging to the class denoted by the table name. For example, if you have a table named Student, then each record in that table contains data for one particular student. In the Student table below, you can see that the column names reflect the kind of data they contain. For instance the Name column stores the names of students, the GraduationYear column stores graduation years, etc.

Id Name YearBorn GraduationYear
1 Kyle Lawson 1992 2015
2 Santiago Knox 1991 2015
3 Arian Sheppard 1990 2013
4 Samuel Foster 1991 2014
5 Hayden Smith 1986 2010


Click Next exercise to continue.