Examine the following table:
In the table, you deleted the record of Mark Smith.Which of the following will change as a result?
A.
Degree of the table
B.
Cardinality of the table
C.
Domain of the table
D.
Attribute of the table
Explanation:
In tables, the number of rows (or tuples) is calledthe cardinality. When a record (or row) of the table is deleted
(or added), the cardinality of the table changes. Answer A and D When a column of the table is changed, the
degree (or attribute is changed). The degree of a table refers
to the number of columns that a table has. The number of columns contained in a table is referred to by the
term degree of the table; if the
degree of a table is increased by 1, it means that a new column is added to the table. The degree of the table
denotes the number of columns
or attributes.
Answer C is incorrect. A Domain is a set of allowable values for one or more attributes. It is also known as the
data domain which refers to all the unique values which a data element may contain. The Domain boundary
can be defined by rules such as a the data type with an enumerated list of values. Check constraint isalso a
simple example of defining the boundary of a domain.
In tables, the number of rows (or tuples) is called the cardinality.