21.2. Database concepts¶

When you first look at a database it looks like a spreadsheet with multiple sheets. The primary data structures in a database are: tables, rows, and columns.

In technical descriptions of relational databases the concepts of table, row, and column are more formally referred to as relation, tuple, and attribute, respectively. We will use the less formal terms in this chapter.

Q-1: Match each data structure used in databases to its formal counterpart.

Think about what the terms on the left could mean outside of databases and how they could relate to the terms on the right.

Attribute
Column
Tuple
Row
Relation
Table