What is a Table, Row, and Column?

Understanding Tables, Rows, and Columns

A table is a collection of data organized in rows and columns. It resembles a spreadsheet.

Table

A table represents an entity (like Employees, Products, Orders).

Row

Each row is a record or tuple. It represents a single data entry.

Column

Each column defines a field, such as employee_id or name, with a specific data type.

Example:

| employee_id | name     | salary |
|-------------|----------|--------|
| 101         | Alice    | 60000  |
| 102         | Bob      | 75000  |