About

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

Role

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.

morelessAdd your answer
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

morelessAdd your answer
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
thegatebook's picture
KIRAN KUMAR
gatelectures's picture
Himanshu Kaushik
sumitverma's picture
Sumit Verma
amrithkrishn's picture
Amrith Krishna
virtualgate's picture
Virtual GATE
shivamkori's picture
shivam
rajeshkpandey008's picture
Rajesh Kumar Pandey
vivek14's picture
Vivek Vikram Singh
ranita's picture
Ranita Biswas
pritam's picture
Pritam Prasun
Raju Chityala
17914
rajibkar's picture
Rajib Kar
24485
Kuldip Gusani
36314
21 Feb 2016 - 5:37pm

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

more less