Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started