Come on in! Qfeast is the easiest way to create online quizzes, stories, questions, polls, interest pages, all in one place
Join now...it only takes a moment!
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.
Write out the skeleton tables for your answer to a)