279 views
1 votes
1 votes
The following TRC query represents ____________.

{E ∈ employee (T.ename = E.ename ^ E.salary > 5000)}

(A) Find all employees of salary above 5000
(B) Find names of all employees of salary above 5000
(C) Find salaries of all employees of salary above 5000
(D) Find name and salary of employees of salary above 5000

1 Answer

1 votes
1 votes
The TRC should have been {T|E ∈ employee (T.ename = E.ename ^ E.salary > 5000)}

Now as the tuple variable is T, the query will fetch name and salary of employees of salary above 5000.
Hence Option D
edited by

Related questions

1 votes
1 votes
1 answer
1
Harikesh Kumar asked Jan 13, 2018
397 views
Provide the correct answer
0 votes
0 votes
1 answer
4
rayhanrjt asked Jan 6, 2023
719 views
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.