Basic Data Mining Concepts

CASE Table
A Case table has Attributes (columns) and States (values).
==> Equivalent to the Dimension Table in Data Warehousing
Case key = the PK of the table

NESTED Table
Nested case - the many part of the relationship.
==> Equivalent to the Fact Table in Data Warehousing
Nested key = Not the FK (i.e. the PK of the table). Important: It is rather the other attributes that make up the nested key.

Reference
Data Mining with SQL Server 2005 by ZhaoHui Tang and Jamie MacLennan