$1-$ Define the five basic relational algebra operations. Define the Join, Intersection, and

Division operations in terms of these five basic operations.

$2-$ Discuss the differences between the five Join operations: Theta join, Equijoin, Natural

join, Outer join, and Semijoin. Give examples to illustrate your answer.

A$)$ For following questions, you should formulate the following queries in relational

algebra according to relational schemas that are depicted below.

Employee $($empNo$,$ fName, IName, address, DOB, sex, position, deptNo$)$

Department $($deptNo$,$ deptName,mgrEmpNo$)$

Project $($projNo$,$ projName, deptNo$)$

WorksOn $($empNo$,$ projNo, dateWorked, hoursWorked$)$

List all employees.

List all the details of employees who are female.

List the names and addresses of all employees who are managers.

Produce a list of the names and addresses of all employees who work for the IT

department.

Produce a list of the names of all employees who work on the SCCS project.

Produce a complete list of all employee whose manager name is "Zoran."

B$)$ What are the results of following relational algebra operations?

Tables: $1-{}_{\text{n}\text{a}\text{m}\text{e}}($student$)$

$2-{}_{\text{c}\text{o}\text{d}\text{e}}=cpl500$ OR code$=$cp $3010($subject$)$

$3-$ student $|><msub\; id="EditorElement\_4800699"><mrow><mi\; id="EditorElement\_4800674">|</mi></mrow><mrow\; id="EditorElement\_4800698"><mtext\; id="EditorElement\_4800677">e</mtext><mtext\; id="EditorElement\_4800679">n</mtext><mtext\; id="EditorElement\_4800681">r</mtext><mtext\; id="EditorElement\_4800683">o</mtext><mtext\; id="EditorElement\_4800685">l</mtext><mtext\; id="EditorElement\_4800687">l</mtext><mtext\; id="EditorElement\_4800689">e</mtext><mtext\; id="EditorElement\_4800691">d</mtext><mtext\; id="EditorElement\_4800693">I</mtext><mtext\; id="EditorElement\_4800695">n</mtext></mrow></msub>$

$4-$student $-{}_{\text{n}\text{a}\text{m}\text{e}-\text{l}\text{i}\text{n}\text{g}}($student$)$

$5-$student enrolledln.$id$ enrolledIn

$6-($student $\{$:$|><msub\; id="EditorElement\_4800401"><mrow><mi\; id="EditorElement\_4800374">|</mi></mrow><mrow\; id="EditorElement\_4800400"><mtext\; id="EditorElement\_4800377">e</mtext><mtext\; id="EditorElement\_4800379">n</mtext><mtext\; id="EditorElement\_4800381">r</mtext><mtext\; id="EditorElement\_4800383">o</mtext><mtext\; id="EditorElement\_4800385">l</mtext><mtext\; id="EditorElement\_4800387">l</mtext><mtext\; id="EditorElement\_4800389">e</mtext><mtext\; id="EditorElement\_4800391">d</mtext><mtext\; id="EditorElement\_4800393">I</mtext><mtext\; id="EditorElement\_4800395">n</mtext><mtext\; id="EditorElement\_4800397"></mtext></mrow></msub><mi\; id="EditorElement\_4800403">)</mi>$

$8-$ subject $\{$:${?}_{\text{e}\text{n}\text{r}\text{o}\text{l}\text{l}\text{e}\text{d}}{}_{\text{s}\text{t}\text{u}\text{d}\text{e}\text{n}\text{t}})$

$9-$Who teaches cp $1500?$