Properties of Relational Tables in Sql Server

Sql Server database is a complete RDBMS system as it follows all 12 rules of CODD which defines a database system as RDBMS. For making a RDBMS or DMBS system proper as database design for table should also be in a proper defined manner for the ease of access.

There are 6 properties of Relational Tables in sql server and they are as follow,

1) Values Are Atomic
This property implies that columns in a relational table are not repeating group. The key benefit of the one value property is that it simplifies data manipulation logic. This property of tables are even referred to be in the “first normal form” (1NF) of normalisation.

2) Referencing Column Values Are of the Same Kind
In relational terms this means that all values in a column belong to same type. This property simplifies data access because developers and users can be certain of the type of data contained in a given column. It also simplifies data validation. Because all values are from the same domain, the domain can be defined and enforced with the Data Definition Language (DDL) of the database software.

3) Each Row is Unique
This property ensures that no two rows in a relational table are identical. there is at least one column, or set of columns, the values of which uniquely identify each row in the table. Such columns are called primary keys. This property guarantees that every row in a relational table is meaningful and that a specific row can be identified by specifying the primary key value.

4) The Sequence of Columns is Insignificant
This property states that the ordering of the columns in the relational table has no meaning. Columns can be retrieved in any order and in various sequences. The benefit of this property is that it enables many users to share the same table without concern of how the table is organized. It also permits the physical structure of the database to change without affecting the relational tables.

5) The Sequence of Rows is Insignificant
This property is analogous the one above but applies to rows instead of columns. The main benefit is that the rows of a relational table can be retrieved in different order and sequences. Adding information to a relational table is simplified and does not affect existing queries.

6) Each Column Has a Unique Name
Any database system does not allow duplicate column names in database table however this is defined as a property that column name need to be unique within the table.