Time Left - 15:00 mins

# GATE CS 2022 : Database-1

Attempt now to get your rank among 315 students!

Question 1

Find attribute closure of (CD)+ in R(ABCDE):

ABC,

BD,

CE,

DA

Question 2

A functional dependency set

F = {A B, BC E, ED A, EF G, E F}

Find the closure of (AC)

Question 3

Consider a relational schema R = {A, B, C, D, E, F, G} and the following functional dependencies hold: {AB⇒C, BC⇒ D, E⇒A, D⇒E, F⇒G}.
The highest NF that R satisfies is

Question 4Multiple Correct Options

In which of the following relation in 2 NF?

Question 5

Suppose relation R(ABC) has the tuples:

How many tuples resulted by given Relational Algebra expression?

πA,B(R)R.B<S.BρS(A,B) (πB.C(R))

Question 6

The STUDENT information in a university stored in the relation STUDENT (Name, SEX, Marks, DEPT_Name). Consider the following SQL Query

SELECTDEPT_Name

FROM STUDENT

WHERE SEX = ‘M’

GROUP BYDEPT_Name

HAVINGAVG (Marks)>SELECT AVG (Marks) FROM STUDENT.

It Returns the Name of the Department for which:

• 315 attempts