(a) Consider the tables given below STUDENT_NAME EMPLOYEE_NAME B A STUDENT_ID 1001 1002 1003 1004 1005 B D E EMPLOYEE_ID 1001 1002 1003 1004 1005 mow E Give the complete relational algebra expression using appropriate relational algebra operators to get the below outputs (BOTH THE TABLES MUST BE USED IN THE EXPRESSION) i) STUDENT_ID STUDENT_NAME ALUMNI_ID ALUMNI_NAME 1001 A 1003 D ii) STUDENT_ID 1004 1003 (b) (3 Marks) Consider the relation R (A, B, C, D) where D->A, B, C. i) Identify the dependencies in the above given relation. ii) Explain what is 'functional dependency' and 'fully functional dependency'. (a) Consider the tables given below STUDENT_NAME EMPLOYEE_NAME B A STUDENT_ID 1001 1002 1003 1004 1005 B D E EMPLOYEE_ID 1001 1002 1003 1004 1005 mow E Give the complete relational algebra expression using appropriate relational algebra operators to get the below outputs (BOTH THE TABLES MUST BE USED IN THE EXPRESSION) i) STUDENT_ID STUDENT_NAME ALUMNI_ID ALUMNI_NAME 1001 A 1003 D ii) STUDENT_ID 1004 1003 (b) (3 Marks) Consider the relation R (A, B, C, D) where D->A, B, C. i) Identify the dependencies in the above given relation. ii) Explain what is 'functional dependency' and 'fully functional dependency