reset password
Author Message
intregrisist
Posts: 41
Posted 20:10 Oct 25, 2010 |

I'm having a little trouble understanding e.  Since the professor is part of the Faculty table and each faculty belongs to a department (see below) is it saying that the professor teaches classes that are of his department only?


Faculty: id, name, department_id

cysun
Posts: 2935
Posted 08:17 Oct 26, 2010 |

No. The problem description says "All of the courses ... by the same department", not "by his or her department". It means that, for example, a CS professor can teach Math courses, as long as he or she teaches only Math classes.

ptran6
Posts: 25
Posted 11:29 Oct 26, 2010 |

Dr. Sun,

I asked you the same question in http://csns.calstatela.edu/forum/viewTopic.html?topicId=2779037 and you said yes. Am I misunderstanding something here?

- Peter Tran

intregrisist
Posts: 41
Posted 12:58 Oct 26, 2010 |

Hey, that's right.  Tran asked the exact same question and the reply was yes.  The thing is, it doesn't make sense for a faculty member belonging to, lets say, the Math department and is only stuck teaching, e.g., drama classes.

cysun
Posts: 2935
Posted 13:39 Oct 26, 2010 |
ptran6 wrote:

Dr. Sun,

I asked you the same question in http://csns.calstatela.edu/forum/viewTopic.html?topicId=2779037 and you said yes. Am I misunderstanding something here?

- Peter Tran

My bad. I think my original understanding is wrong, but you if do it that way, it's fine, too.