That's cleared everything up Thanks timothybard.

I give up thanks for your time timothybard your advice was really good I just struggled to get to terms with database design.

I started from scratch and listed the basic tables that I could find. I then decided that between all the tables there are many to many relationships so I did this:

student
student/course
Course...

I am so confused now I don’t know why I removed it I guess I just kind of panicked and thought I didn’t need it thanks for pointing it out it will go back in.

It doesn’t state that a tutor is the...

I tired to take on board everything that you said and this is what I come up with.

Each member of staff is only able to teach certain modules or even certain sessions of certain modules. Members of staff have line-mangers who report to the head of department

For some reason this...

I will drop the academic table and the head of office.

Thanks

Lastly, you need to review your relationships.

I am having a massive problem finding theses many to many relationships, I have...

I have tried to do what you suggested timothybard my new er diagram is attached what do you think?

I wasn't sure if I should have the student entity to the modules entity 1 to many or student to...

I see what you are saying now I have modules one to many to facilities and facilities many to one to room.

I still cant find any more entities that I need, if anybody sees any that I have missed,...

I was told that if I had a many to many relationship then I had to create a new table is this not true?. I have attached a document that shows the format of the assignment.

Thanks again.

Thanks for your advice REALLY APPRECIATED

How can you track if a student wants to take a module that is not within his course?
Can you explain the purpose of the studies entity?

I thought...

Hi, I have produced an er diagram for an assignment which I have attached. Can somebody please tell me if it is correct and if not can you please let me know where I went wrong

Thanks