Relational Algebra

$$\bowtie$$

$\rho$

$\cup$

$\setminus$

$\times$

$$\pi_{PubID, Name, ISBN} (Books \bowtie Publisher) \div \pi_{ISBN} (\sigma_{Category = 'COOKING'} (Books))$$

$Books \mathbin{\text{⟖}} OrderItems$

$Books \mathbin{\text{⟕}} OrderItems$

Exercise

1. $$\pi_{Club\_ID, \space Club\_Name} (\sigma_{Program\_Name \space = \space 'Master of Arts Management'} (CLUB \bowtie MEMBERSHIP \bowtie STUDENT \bowtie PROGRAM)$$

2. $$(\sigma_{C1.Memtor\_ID \space = \space Memtor\_ID \space AND\space C1.Memtor\_ID \space = \space C2.Memtor\_ID \space AND \space C1.Club\_ID \space < \space C2.Club\_ID }((\rho_{C1}(CLUB) \space \times \space \rho_{C2}(CLUB))\times MENTOR)$$

3. $\pi_{Mentor\_ID, \space FName, \space LName}(MENTOR)$

   —

   $\pi_{Mentor\_ID, \space FName, \space LName}(CLUB\space \bowtie \space MENTOR)$

4. $\pi_{Mentor\_ID, \space MENTOR.FName, \space MENTOR.LName, \space Student\_ID, \space STUDENT.FName, \space STUDENT.LName}(MENTOR\bowtie CLUB\bowtie MEMBERSHIP\bowtie STUDENT)$

5. $\pi_{Club\_Name,\space FName, \space LName}(\sigma_{Sem\_Joined \space = 'F19' \space OR \space Sem\_Joined \space = 'S20'})(STUDENT \bowtie MEMBERSHIP \bowtie CLUB)$

6. $\pi_{Student\_ID, \space FName, \space LName}(\sigma_{Sem\_Joined \space = \space 'F19' \space OR \space Sem\_Joined \space = \space 'S19' \space OR \space Sem\_Joined \space = \space 'M19'}(STUDENT \bowtie MEMBERSHIP))$

   —

   $\pi_{Student\_ID, \space FName, \space LName}(\sigma_{Sem\_Joined \space = \space 'F20' \space OR \space Sem\_Joined \space = \space 'S20' \space OR \space Sem\_Joined \space = \space 'M20'}(STUDENT \bowtie MEMBERSHIP))$

7. $\pi_{Mentor\_ID, \space FName, \space LName, \space Email, \space Club\_Name} (MENTOR \space \mathbin{\text{⟖} \space CLUB}))$

8. $\pi_{Student\_ID, \space FName, \space Name, \space Club\_Name}(\sigma_{Club\_Name \space = \space 'Consulting \space Club'}(STUDENT \bowtie CLUB))$

   $\pi_{Student\_ID, \space FName, \space Name, \space Club\_Name}(\sigma_{Club\_Name \space != \space 'Consulting \space Club'}(STUDENT \bowtie CLUB))$

9. $$\begin{align} &\pi_{S1.Student\_ID, \space S1.FName, \space S1.LName, \space S2.Student\_ID, \space S2.FName, \space S2.LName}(\\ &\sigma_{S1.Club\_ID \space = \space S2.Club\_ID \space AND \space S1.Sem\_Joined \space = \space S2.Sem\_Joined \space AND \space S1.Student\_ID < S2.Student\_ID}(\\ &\rho_{S1}(STUDENT\bowtie MEMBERSHIP) \space \times \space \rho_{S2}(STUDENT\bowtie MEMBERSHIP)) \end{align}$$