The Chasm and Fan Trap
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What do Chasm and Fan Traps lead to?
2. How is a Fan Trap defined?
3. In the Fan Trap example, what is the problem with adding Order Id as a foreign key in the Order Products table?
4. What is the suggested solution to the Fan Trap in the Customer, Order and Product example?
5. How is a Chasm Trap defined?
6. In a Chasm Trap, where does the issue lie?
7. In the John example from I Am Datapedia!, how many rows result from joining Employee, Target and Sales in one query, and what total is shown?
8. Which two approaches are given to handle the Chasm Trap?
9. How many rows does the UNION ALL solution produce in the John example?
10. Which rule about transactional and master tables must one not forget when modelling?