I'm trying to find the following
find every department that has a professor who taught all courses offred by that department.
Using relational algebra and then using SQL.
The schema is as follows:
Student(Id:Integer, Name:String, Address:String, Status:String)
Professor(Id:Integer, Name:String, DeptId:String)
Course(DeptId:String, CrsCode:String, CrsName:String, Descr:String)
Transcript(StudId:Integer, CrsCode:String, Semester:String, Grade:String)
Teaching(ProfId:Integer, CrsCode: String, Semester:String)
Any help would be much appreciated, I'm starting think that it is near impossible to represent this in a one line relational algebra formula.
2006-09-29
03:37:34
·
2 answers
·
asked by
patrickdenney2
2
in
Mathematics