Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints


 

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 

Integrity constraints, including functional dependencies, guide the modeling process for relational database systems. They are no less important when designing Cassandra structures – although support can be limited.

This second of the series revolves around four separate problems to solve, each presenting modeling principles in Cassandra and some in SQL Server as well. Each highlights different facets. In the first, tracking surgeries in an OLTP relational