Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 14 of 79

MySQL SQL Revision Tour — Question 7

Back to all questions
7
Question

Question 5(a)

Mr. James created a table CLIENT with 2 rows and 4 columns. He added 2 more rows to it and deleted one column. What is the Cardinality and Degree of the Table CLIENT ?

Answer

For the table CLIENT, the cardinality is 4 and degree is 3.

Explanation — Initially, the table CLIENT created by Mr. James had 2 rows and 4 columns, with a cardinality of 2 and a degree of 4. After modifying the table by adding 2 rows and deleting 1 column, the new cardinality of the table CLIENT is 4 and the degree is 3.