search
Log In
0 votes
391 views
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)))
in Databases 391 views

Please log in or register to answer this question.

Related questions

2 votes
0 answers
1
119 views
Which of the following transaction(s) follow 2-phase locking protocol? lock1(a)read1(a)lock2(b)write2(b)lock1(c)unlock2(b)unclock1(c)lock2(c)unlock1(a) lock1(a)lock1(b)unlock1(a)lock2(a)write2(a)unlock2(a)unlock1(b) lock1(a)lock2(b)lock1(c)lock3(d)unlock2(b)lock3(b)unlock1(a)unlock3(d)unlock1(c)lock3(c) 1. Only 1 2. Only 2 3. Only 1 and 3 4. None of them
asked Sep 29, 2017 in Databases gulsanchouhan 119 views
2 votes
0 answers
2
167 views
Which of the following statement is correct ? 1. 2 phase locking protocol does not suffer with problem of cascading rollback 2. Strict 2 phase protocol never results in deadlock 3. In strict 2 phase protocol, restriction of releasing exclusive locks until commit ensures no cascading rollbacks 4. Time-stamp ordering protocol can generate non-recoverable schedules
asked Sep 29, 2017 in Databases gulsanchouhan 167 views
3 votes
2 answers
3
108 views
Choose the correct option about the following schedule. S:R2(A);W3(A);(commitT3);W1(A);(commitT1);W2(B);R2(C);(commitT2);R4(A);R4(B);(commitT4) 1. S is both recoverable and conflict serializable 2. S is neither recoverable nor conflict serializable 3. S is recoverable but not conflict serializable 4. S is not recoverable but conflict serializable
asked Sep 29, 2017 in Databases gulsanchouhan 108 views
1 vote
0 answers
4
120 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. Map Reduce 2 .OLAP 3. Mahout 4. Cloud Computing
asked Sep 29, 2017 in Databases gulsanchouhan 120 views
...