KwickClips Databases and SQL · 44 sec · free
A table has 3 columns and 4 rows. What is the cardinality?
Short answer. 4.
Does the heading count as a tuple?
No.
Count with me
| Columns: 1, 2, 3 |
| Degree = 3 |
| Rows: 1, 2, 3, 4 |
| Cardinality = 4 |
Remember
| Degree: columns |
| Cardinality: rows |
| Never count the heading |
Which one counts rows, degree or cardinality? Count columns: one, two, three. Degree is three. Count rows: one, two, three, four. Cardinality is four. Degree counts columns. Cardinality counts rows. Never count the heading.
This clip is from the full lesson: The Relational Model: Relation, Tuple, Attribute, Domain, Degree and Cardinality — 6 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 10 Information Technology (402), CBSE Class 12 Computer Science (083), CBSE Class 11 Informatics Practices (065), CBSE Class 11 Information Technology (802)
More KwickClips from this lesson
What is another word for a row?43 sec
What is the domain of marks out of 100?40 sec
Which model allows many parents?42 secVoice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.