723 views
0 votes
0 votes
Consider the following database schema where the primary keys are underlined.

                 Employee(EId, EName, ESal, PId)
                 Project(PId, PName, PDeadline, PBudget).

Which of the following is the most optimized query while retrieving employee names whose salary is more than 1000 and are allocated in a project has a budget more than 50000?

1. ΠEName(σESal>1000∧PBudget>50000(Employee⋈PIdProject)
 
2. ΠEName((σESal>1000(Employee))⋈PId(σPBudget>50000(Project)))
 
3. ΠEName(ΠEName,ESal,PId(σESal>1000(Employee))⋈PIdΠPId,PBudget(σPBudget>50000   (Project)))
 
4. ΠEName(ΠEName,PId(σESal>1000(Employee))⋈PIdΠPId(σPBudget>50000(Project)))

Please log in or register to answer this question.

Related questions

1 votes
1 votes
0 answers
4
gulsanchouhan asked Sep 28, 2017
343 views
Which of the following can be described as a programming model used to develop applications processing massive amounts of data in a distributed and/or parallel manner?1. ...