Which of following statements is true for retrieving the Fname, Lname and addres

Question

Which of following statements is true for retrieving the Fname, Lname and address for the employee working in the ‘Research’ department?
Select one:
a. SELECT EMPLOYEE.Fname, EMPLOYEE.LName,
EMPLOYEE.Address
FROM EMPLOYEE, DEPARTMENT
WHERE DEPARTMENT.Dnumber=EMPLOYEE.Dno;

b. SELECT Fname, EMPLOYEE.Name, Address
FROM EMPLOYEE, DEPARTMENT
WHERE DEPARTMENT.Name=‘Research’ AND
DEPARTMENT.Dnumber=EMPLOYEE.Dnumber;

c. SELECT E.Fname, E.Lname, S.Fname, S.Lname
FROM EMPLOYEE AS E, EMPLOYEE AS S
WHERE E.Super_ssn=S.Ssn;

d. SELECT E.Fname, E.LName, E.Address
FROM EMPLOYEE E, DEPARTMENT D
WHERE D.DName=‘Research’ AND D.Dnumber=E.Dno;

Explanation / Answer

Out of these 4 options, option d is the correct one. Statements in option d choose first name, last name and address of those employees who work in Research dept.

option a choose first name, last name and address of those employees who work in any of the dept.

option b doesn't give employee's last name.

option c gives name of the employees whose super_ssn = ssn.

Hope it helps, feels free to comment in case of any query.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.