RDBMS Concepts

RDBMS stands for relational database management system. A relational database has following major components: Table, Record / Tuple, Field & Column /Attribute.

Table:
A table is a collection of data represented in rows and columns. For e.g. following table stores the information of students.

Records / Tuple:
Each row of a table is known as record or it is also known as tuple. For e.g. The below row is a record.

Field:
The above table has four fields: Student_Id, Student_Name, Student_Addr & Student_Age.

Column / Attribute:
Each attribute and its values are known as attributes in a database. For e.g. Set of values of Student_Id field is one of the four columns of the Student table.