You, as a systems analyst and designer, were asked to develop a Bank of Questions for each course in the University. As you know there are many programs such as Science, Engineer, and IT. Each college has its own programs. Each program has a group of courses. Each program has a group of instructors. Each instructor may teach more than one course and each course may be delivered by more than one instructor during the academic semesters. The proposed system should keep of instructor ID, instructor name, course code, course name, and course credit hours. Each course has a group of lectures. Each lecture has a group of multiple choice questions (MCQ). Each question has four different possible answers. Only one of these answers is correct. Since each course has a group of assessment test, the system should keep track of assessment name, assessment data and time, and total number of questions. A student may have many tests during the academic year where questions are selected randomly for each student. If the answer of a student for a specific question is right, the student will get the score of the question. If it is wrong, the student will get zero for that question. The proposed system should register student answer and score for each question and display student total score for each test.

An instructor can set test date and time, number of test questions, decide the weight of each question, select, modify, and delete questions. A student can read testquestions, answer, modify answer, resit for another test if he/she has a formal excuse, and know its final score. At the end of the semester, admission and registration office employee is responsible for declaring final result.

1. draw the Conceptual Data Model (ERD)