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 called the 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 is also a simple example of defining the boundary of a domain.