What is the table?

RDBMS uses tables to store the data. A table is a collection of related data which is stored in rows and columns.

A simple example table in RDBMS looks like below:
Let us take an example of Employee table

 

ID NOEmployee NameDesignationAge
1AjayDesigner26
2DeepakDeveloper30
3RakeshAccountant28
4SrikanthManager35

 

What are row and column?

The row in the table is also called as a record. It contains information about each individual entry in the table. In simple, we can say that is a horizontal entity.

 

1AjayDesigner26

 

The column is a vertical entity which contains information associated with the specific field of a table. For example, the Employee Name is a column which contains all names of employees associated to it as shown below

 

Employee Name
Ajay
Deepak
Rakesh
Srikanth