Is there a correct way of using a lookup table in a DB schema as a CHECK constriant for multiple fields in a single record while defining it as a functional dependency? (FK)
Do I have to handle global updates manually as you cannot have FK contraints agaisnt multiple fields in a record using a lookup table?
If I try to use the lookup table via an FK functional dependency, SQL compliants that 'may cause cycles or multiple cascade paths'.
How do you define a FK constraint to a lookup table, with functional dependency to maintain data integrity against mutiple fields in the same record without this issue?