Hello I'm designing a database for my Computing Science department and I am having some trouble with the ER Diagram. Any help would be great appreciated.
What I have so far is:
Each course has a ID Code, title, is taken by one or more students and is taught by one or more lecturers.
Each course has none or more tutorial groups.
A tutorial group has one or more students and only one tutor.
Tutors are members of staff with a status of full-time/part-time.
Each student has a unique matriculation number, a name and email address.
Each student has an assessment for each course they take consisting of an exam mark in the range 0-100 and a practical mark in range 0-20.
Lecturers have a photocopy budget and all lecturers are a member of staff with a unique staff number, a name and a status(e.g Research assistant).
All staff members have one manager who is also a member of staff.
I know I have missed things out/put entities in the wrong place therefore any help would be great.