Question

Given the following database where primary key attributes are underlined: employee(employee_name, city, street) works(employee_name, company_name, salary) company(company_name, city, street) We want to find the employee_name, city of residence, and salary for all employees who work for the company Fedco. Which of the following queries is NOT a correct way for doing that? O SELECT employee_name, city, salary FROM employee natural join works WHERE company_name = 'Fedco'; O SELECT employee.employee_name, city, salary FROM employee, works WHERE employee.employee_name = works.employee_name and company_name = 'Fedco'; O SELECT employee.employee_name, city, salary FROM employee, works WHERE (employee.employee_name, company_name) = (works.employee_name, 'Fedco'); O None of these

          Given the following database where primary key attributes are underlined:
employee(employee_name, city, street)
works(employee_name, company_name, salary)
company(company_name, city, street)
We want to find the employee_name, city of residence, and salary for all employees who work for the company Fedco. Which of the following queries is NOT a correct way for doing that?
O SELECT employee_name, city, salary FROM employee natural join works WHERE company_name = 'Fedco';
O SELECT employee.employee_name, city, salary FROM employee, works WHERE employee.employee_name = works.employee_name and company_name = 'Fedco';
O SELECT employee.employee_name, city, salary FROM employee, works WHERE (employee.employee_name, company_name) = (works.employee_name, 'Fedco');
O None of these

Given the following database where primary key attributes are underlined:
employee(employeename, city, street)
works(employeename, companyname, salary)
company(companyname, city, street)
We want to find the employeename, city of residence, and salary for all employees who work for the company Fedco. Which of the following queries is NOT a correct way for doing that?
O SELECT employeename, city, salary FROM employee natural join works WHERE companyname = 'Fedco';
O SELECT employee.employeename, city, salary FROM employee, works WHERE employee.employeename = works.employeename and companyname = 'Fedco';
O SELECT employee.employeename, city, salary FROM employee, works WHERE (employee.employeename, companyname) = (works.employeename, 'Fedco');
O None of these

Added by Julie F.

Question

Please give Ace some feedback