CREATE TABLE TiberDM.StepOneExamFact (
    id                  MEDIUMINT       NOT NULL AUTO_INCREMENT,
    StepOneExamDimId    MEDIUMINT       NOT NULL,
    StepOneStudentDimId MEDIUMINT       NOT NULL,
    PassFail            VARCHAR(4)      NOT NULL,
    Score               MEDIUMINT       NOT NULL,
    PRIMARY KEY (id)
);

Create Unique Index StepOneExamDim_UIdx01
On TiberDM.StepOneExamFact (StepOneExamDimId, StepOneStudentDimId);
