Aspire Faculty ID #18512 · Topic: UGC NET Computer Science Dec 2022 Shift I (Paper II) · Just now
UGC NET Computer Science Dec 2022 Shift I (Paper II)

Consider the relation
$R(P,Q,R,S,T,U,V,W,X,Y)$ and FDs:

${P,Q,S}\to T$

$R\to Y$

${P,Q}\to V$

${R,X}\to X$

$Q\to U$

$V\to {W,X}$

Which of the following is a candidate key?

Solution

Find closure of ${P,Q,R,S}$.

${P,Q,S}\to T$

So, we get $T$.

$R\to Y$

So, we get $Y$.

${P,Q}\to V$

So, we get $V$.

$Q\to U$

So, we get $U$.

$V\to {W,X}$

So, we get $W$ and $X$.

Therefore,

$(P,Q,R,S)^+={P,Q,R,S,T,U,V,W,X,Y}$

It contains all attributes of the relation.

Previous 10 Questions — UGC NET Computer Science Dec 2022 Shift I (Paper II)

Nearest first
1
A _____ operation combines the rows of the two relations and outputs a new relation that has both input relations' rows…
Topic: UGC NET Computer Science Dec 2022 Shift I (Paper II)
2
In _____ curve the last and the first vertices of the polygon lie on the curve and all other vertices define the deriva…
Topic: UGC NET Computer Science Dec 2022 Shift I (Paper II)
3
Allowing different derived classes to be used interchangeably through the interface provided by a common base class is …
Topic: UGC NET Computer Science Dec 2022 Shift I (Paper II)
4
Givenint arr[3][4][2] ={  {{2,4},{7,8},{3,4},{5,6}},  {{7,6},{3,4},{5,3},{2,3}},  {{8,9},{7,2},{3,4},{5,…
Topic: UGC NET Computer Science Dec 2022 Shift I (Paper II)
5
In the context of Binding which one of the following is incorrect?
Topic: UGC NET Computer Science Dec 2022 Shift I (Paper II)
6
Let $R_1$ and $R_2$ be two $4$-bit registers that store numbers in $2$'s complement form. For the operation $R_1+R_2$, …
Topic: UGC NET Computer Science Dec 2022 Shift I (Paper II)
7
Consider a $3$-bit counter, designed using $T$ flip flops as shown below. Assume the initial state of the counter give…
Topic: UGC NET Computer Science Dec 2022 Shift I (Paper II)
8
What is the minimum number of students in a discrete mathematics class to be sure that at least six will receive the sa…
Topic: UGC NET Computer Science Dec 2022 Shift I (Paper II)
9
The coefficient of $x^2y^3z^2$ in the expansion of $(x+y+z)^7$ is
Topic: UGC NET Computer Science Dec 2022 Shift I (Paper II)
10
Seven people enter a lift. The lift stops only at three floors which are unspecified. At each of the three floors, no o…
Topic: UGC NET Computer Science Dec 2022 Shift I (Paper II)

Next 10 Questions — UGC NET Computer Science Dec 2022 Shift I (Paper II)

Ascending by ID
Ask Your Question or Put Your Review.

loading...