what is the degree of the table in sql
Answers
Answered by
0
Answer:
The degree of a relation is the number of attributes in its header, or, in other words, the number of columns. It is also used for tuples/records, in which case it refers to the number of fields.
Answered by
1
Answer:
In SQL (Structured Query Language), the term cardinality refers to the uniqueness of data values contained in a particular column (attribute) of a database table. The lower the cardinality, the more duplicated elements in a column. Thus, a column with the lowest possible cardinality would have the same value for every row. SQL databases use cardinality to help determine the optimal query plan for a given query.
Similar questions