1D0-541 Exam - Question 11

The given relational algebraic expression first performs a projection to select specific columns from the Customers and Employees tables, then performs a natural join on the Sales_Rep_No column between Customers and Employees. The SQL statement equivalent to this should select Cust_No, Cust_Name from Customers and Emp_Name, Emp_Loc from Employees where Customers.Sales_Rep_No is equal to Employees.Sales_Rep_No. Option C is correct because it projects Cust_No, Cust_Name from Customers and Emp_Name, Emp_Loc from Employees and joins on Customers.Sales_Rep_No, matching the relational algebraic expression.