0

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.

-----------

COURSE
ID Code
Title

STUDENT
Matriculation Number
Assessment
Name
Email

LECTURER
Staff Number
Photocopy Budget
Name
Status

STAFF
Manager

TUTOR
Status

I know I have missed things out/put entities in the wrong place therefore any help would be great.

2
Contributors
1
Reply
3
Views
8 Years
Discussion Span
Last Post by timothybard
0

I would recommend adding a tutorial group entity and a student assessment entity. I would remove the name attribute from the lecturer entity and add it to the staff entity. Lastly I would add a staff id attribute to the lecturer and tutor entities.

After making those changes, a few more things would need to be cleaned up, but hopefully you can see the direction I am going and make more changes as needed.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.