Question 1

What are tables, rows and columns in a database?

Accepted Answer

A table holds one kind of thing, like customers. Each row is one item (one customer) and each column is one detail about it (like their city).

Question 2

What is a real-life example of table, row and column?

Accepted Answer

Think of a class register: the whole sheet is the table, each line is one pupil (a row) and each heading, like "Name" or "Age", is a column.

Question 3

In a Customers table, what is one row?

Accepted Answer

A row is one record: in a Customers table, one row holds one customer with all their details.

Question 4

In the same table, what is the "City" column?

Accepted Answer

A column holds one kind of detail for every row. The City column shows each customer's city.

Question 5

Match each word to what it means.

Accepted Answer

A database holds tables. A table holds one kind of thing. A row is one item and a column is one detail about every item.

id	name	city	email
1	Maya	Lisbon	maya@example.com
2	Tom	Leeds	tom@example.com
3	Aiko	Osaka	aiko@example.com

What are tables, rows and columns in a database?

Try it yourself