The user will refer to the columns of a relational table by name rather than by column position; because of this, each of the columns in a table must have a unique description. The benefits from this characteristic are twofold. First, this will ensure that the data requested by the user is the data that is received by the user. Secondly, since the physical positioning of the column is unimportant, the table can be easily modified without destroying the work done by the user in the past. These same benefits are not achieved using access and manipulation methods that are dependent upon a column being located in a specific position within the table.
Was this article helpful?