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

MySQL SQL Revision Tour — Question 5

Back to all questions
5
Question

Question 4(b)

Mr. Shankar created a table VEHICLE with 3 rows and 4 columns. He added 1 more row to it and deleted one column. What is the Cardinality and Degree of the Table VEHICLE ?

Answer

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

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