Translating a SQL Server Schema into a Cassandra Table: Part III Many-to-Many, Attribute Closure and Solution Space


 

The series so far:

Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints  Translating a SQL Server Schema into a Cassandra Table: Part III Many-to-Many, Attribute Closure and Solution Space 

This last in the series continues with an exploration of the many-to-many relationship. Then it returns to an analysis by functional dependency with attribute closure which is important in establishing “uniqueness” in the Cassandra key and other table properties. Finally, the four solutions to the original problem introduced in