Data Cardinality
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is Data Cardinality about?
2. What is High Cardinality?
3. Which kind of table is mostly in Low Cardinality mode?
4. In the Product and Sales example, why does the Sales table have Low Cardinality with respect to Products?
5. On what basic concept is normalisation said to depend?
6. Why can we NOT say that all primary key tables have absolute highest cardinality?
7. Which of the following is NOT one of the three degrees of cardinality?
8. What does a One to Many (1:M) relationship mean?
9. What can happen when tables are joined using the wrong columns, without direct primary and foreign key relationships?
10. When a table structure changes for a business requirement, what is the first question to ask, and what helps trace the impact?