Discover
Create +
log in
Home
Trending
Quizzes
Stories
Questions
Polls
Pages
Create
Quizzes
Stories
Polls
Questions
Pages
Home
Trending
Sign in
zhangyunye's Questions — Qfeast
ZH
zhangyunye
1
Questions
Bookmark
Profile
Quizzes
Quizzes
Stories
Stories
Questions, 1 published
Questions
1
Polls
Polls
Pages
Pages
Photos
Photos
Connections
Connections
Profile
Quizzes
Quizzes
Stories
Stories
Questions, 1 published
Questions
1
Polls
Polls
Pages
Pages
Photos
Photos
Connections
Connections
Created 1
Starred
QUESTION
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)
Answer