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)
Answers (0)
Be the first to answer