Press "Enter" to skip to content

Properties of Relational Tables

0

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

Share
Share