Relational Algebra Quiz:

  • Tables:
    • employee(personName,street,city)
    • works(personName,companyName,salary)
    • company(companyName,city)
  • Find names of all employees who work for "First Bank Corporation"(FBC)
    • $\Pi_{\text{personName}}(\sigma_{\text{companyName="FBC"}}(\text{works}))$
  • Find the names and city of residence for all employees who works FBC
    • $\Pi_{\text{personName,city}}(\text{works}\bowtie_{\text{companyName="FBC"}} \text{employee})$
  • Find the
    • $\Pi_{\text{personName,street, city}}(\text{works}\bowtie_{\text{companyName="FBC"}\wedge salary>1000} \text{employee})$