A relational table has the following properties:-

  • The table has a name that is distinct from all other tables in the database.

  • Each cell of the table contains exactly one value. (For example, it would be wrong to store several telephone numbers for a single branch in a single cell. In other words, tables don’t contain repeating groups of data. A relational table that satisfies this property is said to be normalized or in first normal form.)

  • Each column has a distinct name.

  • The values of a column are all from the same domain.

  • The order of columns has no significance. In other words, provided a column name is moved along with the column values, we can interchange columns.

  • Each record is distinct; there are no duplicate records.

  • The order of records has no significance, theoretically.

Back to Main