I think there is no ambiguity about question 8 in ER Exercise #3. The fewest number of professors who can have a position in a college is 0. The reason is that a college can have 0 departments. No departments means no professors with positions.
If you start your analysis by looking at Prof first and making your way through Position and Dept to get to College, all you find out is that if there is a professor, there has to be a department and that if there is a department, then there has to be a professor. However, this does not mean there has to be a professor. Your analysis has to start by looking at College entity first.
Comments