Describe the bug
A clear and concise description of what the bug is.
CONSTRAINT [FK_FactK12GraduationCohorts_CohortStatusId] FOREIGN KEY ([CohortId]) REFERENCES [RDS].[DimCohortStatuses] ([DimCohortStatusId]) should be using CohortStatusId. This leads to one field in the fact table being FK referenced to two different dimensions.
Describe the bug
A clear and concise description of what the bug is.
CONSTRAINT [FK_FactK12GraduationCohorts_CohortStatusId] FOREIGN KEY ([CohortId]) REFERENCES [RDS].[DimCohortStatuses] ([DimCohortStatusId]) should be using CohortStatusId. This leads to one field in the fact table being FK referenced to two different dimensions.