Entity-Relationship (E-R) Question

For the following scenario:

When students enrol on a course they are assigned to a personal tutor. Personal tutors are members of the teaching staff who have a secondary role as pastoral care staff. Lecturers teach on courses and may teach a number of modules or subjects associated with a course. A module may be taught by a single member of staff or several tutors may share a module.

Students enrol on a course and each course is made up of a number of modules taught over at least one year, although most courses last longer. Each module has a number of assessments associated with them and all of them have an end of year exam.


a) Construct an Entity-Relationship (E-R) model to document the data needs for the above scenario. Please state any assumptions you make.


b) Write out the skeleton tables for your answer to a)