Create Table TiberDM.StepOneCategoryFact (
    id                      MEDIUMINT       NOT NULL AUTO_INCREMENT,
    StepOneExamDimId        MEDIUMINT       NOT NULL,
    StepOneStudentDimId     MEDIUMINT       NOT NULL,
    StepOneCategoryDimId    MEDIUMINT       NOT NULL,
    StartScore              DECIMAL(10,2)   NOT NULL,
    MidScore                DECIMAL(10,2)   NOT NULL,
    EndScore                DECIMAL(10,2)   NOT NULL,
    Spread                  DECIMAL(10,2)   NOT NULL,
    StdDev                  DECIMAL(10,2)   NOT NULL,
    Primary Key (id)
);

Create Unique Index StepOneCategoryFact_UIdx01
On TiberDM.StepOneCategoryFact(StepOneExamDimId, StepOneStudentDimId, StepOneCategoryDimId);

