23F-A1 (1)

4. Use Relational Algebra (ALG) to express the following queries based on the above database. Submit your ALG expressions for each query as well as the query result. Each query is 4 marks and the result is 2 marks (60) 1) Get the age of Last . 2) Get the name of Last’s manager 3) Get the name of the employee who works on GPU project. 4) Get the name of the employee who does not work on any project. 5) Get the pair of employee name and project name such that the employee works on the project less than 300 hours. 6) Get the name of the employee who works on every project 7) Get the name of the employee who works on every project except SSD. 8) Get the name of the employee who works on every project that Clark works on. 9) Get the name of the employee who works on the same projects that Clark works on. 10) Get the name of the employee who works on more than two projects. Employees E# Name Age Manager E1 Adam s 50 E2 Blake 40 E1 E3 Clark 35 E1 E4 David 30 E3 E5 Emily 25 E4 E6 Last 20 E5 Workon E# P# Hours E1 P1 700 E2 P1 300 E2 P2 200 E3 P1 100 E3 P2 200 E3 P3 300 E4 P1 100 E4 P2 200 E4 P3 300 E6 P1 200 E6 P2 300 E6 P3 400 E6 P4 500 Projects P# Name Location P1 CPU B1 P2 GPU B2 P3 GPU B2 P4 SSD B3