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

Re: Can you please check my ER Diagram?

 
0
  #2
Nov 10th, 2008
Your current ER Diagram is a good start, but let me ask you some questions that may make you want to change your diagram a little:

1) How can you track if a student wants to take a module that is not within his course? ("a student may take one module at each level from outside their course")

2) How do you track which facilities are needed for each module? I see your diagram supports modules using facilities; however, how do you know if the facilities assigned to the module meet the needs for the module?

3) Can you explain the purpose of the studies entity? The reason I ask is because I was wondering how you are tracking which course each module belongs in.

4) I would recommend tracking credits as an attribute of one of the existing entities. can you identify the entity I would add it to?

5) Instead of having tutors directly joined to modules, I would recommend having a different entity directly joined to modules. Do you know which entity it is?
Reply With Quote