Final Year CS Student. GATE Aspirant. Trying to make a contribution towards free education.

### Alma Mater:

Btech
Institute of Engineering and Management, Kolkata
2012 to 2016

### Experience:

Not updated.
Babytud
Example text
2 years 4 months ago

Consider the set of relations:

EMP(Employee-no,Dept-no,Employee-name,Salary)

DEPT(Dept-no, Dept-name,Location)

Write an SQL Query to :

a)Find all employee names who work in departments located at "Calcutta" and whose salary is greater than Rs.50,000

b)Calculate for each department number,the number of employees with a salary greater than Rs.1,00,000

moreless
Babytud
Example text
2 years 4 months ago

Consider the join of a relation R with a relation S. If R has m tuples and S has n tuples then the maximum and minimum sizes of the join respectively are :

a) m+n and 0

b) mn and 0

c)m+n and |m-n|

d)mn and m+n

moreless
Babytud
2 years 4 months ago

Sorry I didn't notice.I will update the question.

Babytud
Doubt
2 years 4 months ago

A relation R has attributes A,B,C,D,E and satisfies the following FDs:

A->BC, B->D, CD->E, E->A

Consider the following decompositions (D1 and D2) of R:

D1: (A,B,C) and (A,D,E)
D2: (A,B,C) and (C,D,E)

Which of the following is true?

A) Both D1 and D2 are lossless decomposition
B) D1 but not D2 is a lossless decomposition
C) D1 but not D1 is a lossless decomposition
D) Neither D1 nor D2 is lossless decomposition

Babytud
Example text
2 years 4 months ago

A tourist covers half of his journey by train at 60 km/h, half of the remainder by bus at 30 km/h and the rest by cycle at 10 km/h. The average speed of the tourist in km/h during his entire journey is

(A)36   (B)30   (C)24   (D)18

moreless
KIRAN KUMAR
Himanshu Kaushik
Sumit Verma
Amrith Krishna
Virtual GATE
shivam
Rajesh Kumar Pandey
Vivek Vikram Singh
Ranita Biswas
Pritam Prasun
Raju Chityala
17914
Rajib Kar
24485
Kuldip Gusani
36314
21 Feb 2016 - 5:37pm

Sorry I didn't notice.I will update the question.

more less