Relational Algebra(关连式代数),高手请进

[changeking]

Relational Algebra(关连式代数)，好像这个领域是关于transaction管理的范围，能不能用relational algebra divide解决掉这题？或者举个例子讲一下关连式代数，小弟陷入郁闷中

List any degree courses which have programmes with modules with all of those modules registered on by Pablo Picasso. (Hint: this is an example of relational algebra divide)
用关连式代数分离法（relational algebra divide）列出任何的具有Pablo Picasso注册了的课程（modules）的学位（degree courses）
（翻译的不知道准不准确）

下面是表的数据：
-------------
degreecourse |
-------------|
courseID(PK) |
courseTitle |
-------------

-------------
student |
-------------|
studentID{PK)|
Firstname |
Lastname |
courseID(FK) |
dateEnrolled |
dateWithdrawn|
dateGraduated|
-------------

----------------
registration |
----------------|
studentID(PK,FK)|
moduleID(PK,FK) |
year(PK) |
semester(PK) |
----------------

-------------
module |
-------------|
moduleID(PK) |
moduleTitle |
-------------

-----------------
studyprograme |
-----------------|
moduleID(PK FK） |
courseID(PK，FK）|
moduleStatus |
-----------------

下面是我写的关连式代数（未完成）：
project studyprogramme over courseid,moduleid giving A
project module over moduleid giving B
divide A by B giving C
join degreecourse,C over courseid giving result

[changeking]

来个人吧,好揭帖

[jdsnhan]

我来也。

[changeking]

拜托高手给个答案吧