CREATE TABLE TiberDM.ExamQuestionFact (
    id                  MEDIUMINT   NOT NULL AUTO_INCREMENT,
    SchoolDimId         MEDIUMINT   NOT NULL,
    AcademicYearDimId   MEDIUMINT   NOT NULL,
    ExamDimId           MEDIUMINT   NOT NULL,
    QuestionDimId       MEDIUMINT   NOT NULL,
    QuestionNo          MEDIUMINT   NOT NULL,
    PEV                 DECIMAL(10,2) NOT NULL,
    PRIMARY KEY (id)
);

Create Unique Index ExamQuestionFact_Uidx01
On TiberDM.ExamQuestionFact (SchoolDimId, AcademicYearDimId, ExamDimId, QuestionDimId);
;
