database

Which one of the following Tuple Relational Calculus queries is equivalent to this SQL query? SELECT Pname FROM Department JOIN Project ON Dnumber=Dnum WHERE Dno = 5; O {p.Pname (3d)DEPARTMENT(D) AND PROJECT() AND d.Dnumber=p.Dnum AND d. Dno = 5} O {Pname (3d)DEPARTMENT(D) AND (3p)PROJECT(D) AND Dnumber=Dnum AND Dno = 5} {p.Pname | DEPARTMENT.Dno = PROJECT.Dnum AND Dno = 5} O {p.Pname | DEPARTMENT(d) AND PROJECT() AND d.Dnumber=p.Dnum AND d.Dno = 5} Which one of the following Relational Algebra queries is equivalent to this SQL query? SELECT Fname AS First_name, Lname AS Last_name FROM Employee, Department WHERE Dno = Dnumber AND Salary > 50000; Pfirst_name, Last_name (TTDno=Dnumber AND Salary>50000 (OFname, Lname (Employee Department))) PFirst_name, Last_name (TTDno=Dnumber AND Salary>50000 (OFname, Lname (Employee Department))) PFirst_name, Last_name (TTFname, Lname (Dno=Dnumber AND Salary>50000 (Employee Department))) TTFirst_name, Last_name (Dno-Dnumber AND Salary>50000 (TTFname, Lname (Employee Department))) The natural join of the below tables DEPARTMENT * DEPT_LOCATIONS will yield a table with how many columns? DEPARTMENT DEPT_LOCATIONS Dname Dnumber Dnumber Dlocation Mgr_ssn 333445555 Mgr_start_date 1988-05-22 Research 5 1 Houston 4 1995-01-01 4 Administration Headquarters 987654321 888665555 Stafford Bellaire 1 1981-06-19 5 5 Sugarland Houston 5 7 6