Answer Happy

Question 1: (10 Marks) Draw an Entity Relationship Diagram for the following scenario: A database is to be designed for a college to monitor students' progress throughout their course of study. The students are reading for a degree within the framework of the modular system. The college provides a number of modules. A module is co-ordinated by a module leader, who is a lecturer. A lecturer may teach (and be a module leader for) more than one module. The college consists of a number of departments; each department employs lecturers from different backgrounds, and offer variety of modules. Also, a module consists of lecture plans, each plan is prepared by a lecturer. It must be observed that some modules require pre-requisites modules. The college database is also to contain some information about students including the grades they attained and the course they enrolled to. Students' grades for each module are recorded. Students can enroll to one course only, in which a number of modules are taught. Some modules are compulsory taught in few courses.