View Single Post
Join Date: Mar 2007
Posts: 306
Reputation: timothybard is an unknown quantity at this point 
Solved Threads: 26
timothybard's Avatar
timothybard timothybard is offline Offline
Posting Whiz

Re: Can you please check my ER Diagram?

 
0
  #8
Nov 12th, 2008
What attributes will be in the academic record entity? Since you will have a credits earned attribute in the studies entity, I was thinking you could get rid of the academic records entity.

Secondly, I'm not sure what the head of office entity is for. My thought would be that the head of office would be an attribute in the department entity.

Also, instead of joining the room to the tutors entity, I would have it joined to the lectures entity because the lecture will be in a specific room.

Lastly, you need to review your relationships. There are a few that are going in the reverse direction and there are a few that need to be many-to-many relationships. If you identify the necessary many-to-many relationships, you may get to the 18 table count you need.
Reply With Quote