Q1. Let consider the given relation schema with the primary keys underlined:
Project(P_No, P_Name, P_Incharge)
Employee(E_No, E_Name)
Assigned_to(P_No, E_No)
Write down the relational algebra expression for the given:
a) List out the details of employees who are working on all projects.
b) List out E_No of employees who are not working on the project number 2K.
c) List all the names of employees who are working in the similar project as employee named ‘Tom’.
d) List all the names of employees who are not working in any of the project.
Q2. Distinguish between the Conflict Serializability and View Serializability of the schedules.