Question: Consider the employee - project relational database in Lecture # 1 : Employee ( EmployeeID, FullName, Salary ) Project ( ProjectID, Description, CompletionYear ) IsAssigned
Consider the employeeproject relational database in Lecture #:
Employee EmployeeID, FullName, Salary
Project ProjectID, Description, CompletionYear
IsAssigned EmployeeID ProjectID, Time
Which of the following SQL queries will list employees with no project assignment?
a Select From Employee Where Time
b Select From Employee Where ProjectID is Null
c Select
From Employee
Where EmployeelD In Select EmployeelD From IsAssigned Where Time
d Select EmployeelD, FullName, Salary
From Employee, IsAssigned
Where EmployeeEmployeelD IsAssigned.EmployeelD And Time
e Select
From Employee
Where EmployeelD Not In Select EmployeelD From IsAssigned
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
