Describe the requirements that a table must meet to qualify as a relation.


  • avatar
    DatabaseExpert
    30 Dec 2012 06:39:03 GMT

     

     

    In order for a table to meet the requirements of a relation, it must satisfy certain conditions.  First, the rows contain data about an entity or some portion of the entity. Second, the columns contain data that represent attributes of the entity – each column must contain the same kind of data for all rows – and each column must have a unique name.   Third, the cells must contain single values – no group or array values are allowed.  Finally, the rows must be unique.  It is worth noting that the order of the columns and the rows is insignificant. 

     


comments powered by Disqus