(b) You Have been asked to prepare an ERD diagram from the following description of a system in CleverClogs University (CCU)

CCU runs many courses. A course consists of modules, a module may be taught in more than one course. A module must be taught by a lecturer. A student takes at least one and not more than six modules. A student must be registered on a course. A lecturer can be course leader of a course. Lecturers get paid on monthly basis depending on employment status: temporary, full time or part time. Lecturer is responsible for grading each module and the grade is recorded in a grade book. The lecturer is also responsible for recording attendance at each lecture. At the end of each semester the students receive a transcript of official results for all modules they registered for.

Identify the entities, appropriate attributes, and the relationships between them. Include cardinality as appropriate.

Identifty3 or 4 attributes for each entity and identify an appropriate primary key.

Prepare an ERD using this information using MySQL Workbench