Before we talk about the relational model in more detail, let us first define some very basic terms used in this model.
Every row in a table shows a record and is called a tuple. A table containing 'n' attributes in a record is called n-tuple.
The name of every column in a table is used to interpret its meaning and is known as an attribute. Every table is called a relation.
For instance, Figure shows a relation PERSON. The columns NAME, PERSON_ID, AGE and ADDRESS are the attributes of PERSON and every row in the table represents a separate tuple (record).
Relation Name: PERSON
Pocket 2, Mayur Vihar.
c-2, New Delhi
Figure: An extended PERSON relation