(ii) If two columns are added and 2 rows are deleted from the table result, what will be the new degree and cardinality of the above table?
Answer:
- Degree refers to the number of attributes/columns in a table.
- Cardinality refers to the number of tuples/rows in a table.
If two columns are added to the table, the new degree will become 8.
If two rows are deleted from the table, the new cardinality will become 5.