A table in rdbms is known as relation.A relation has a two dimensional structure.There are six main properties of relation in rdbms.They are:

Each cell of a table contains single or atomic value.Cell in a relation is the intersection of the row and column.Here single or atomic values means value as whole. Each column in a table has a distinct name and it represents the name of the attributes. The values of the attributes comes from same domain.Domain is the set of all possible values.For example attribute “age” domain is positi\ve integer numbers. The order of column in table is immaterial.if the order of columns in table is changed, it is considered as same table. The order of rows in table is immaterial.if the order of rows in table is changed, it is considered as same table. Each rows/tuple records is distinct, no two eows are same.

Related posts: