Aspire Faculty ID #17525 · Topic: UGC NET Computer Science August 2024 (Paper II) · Just now
UGC NET Computer Science August 2024 (Paper II)

Consider a relation schema $R = (U, V, W, X, Y, Z)$, on which the following functional dependencies hold:


${U \rightarrow V,; VW \rightarrow X,; Y \rightarrow W,; X \rightarrow U}$


The candidate keys of $R$ are:

Solution

Functional dependencies:

$U \rightarrow V$

$VW \rightarrow X$

$Y \rightarrow W$

$X \rightarrow U$


Start with $UY$:

$U \rightarrow V$

$Y \rightarrow W$

Thus we get $V,W$

Then

$VW \rightarrow X$

Then

$X \rightarrow U$

So closure:

$UY^+ = {U,V,W,X,Y}$

Add $Z$ to cover all attributes.

Thus minimal key:

$UYZ$

Similarly:

$VYZ$ and $XYZ$

Thus candidate keys:

$UYZ,; VYZ,; XYZ$

Previous 10 Questions — UGC NET Computer Science August 2024 (Paper II)

Nearest first
1
Which of the following statements are TRUE about mutual exclusion in concurrent programming ? (A) Mutual exclusion ensu…
Topic: UGC NET Computer Science August 2024 (Paper II)
2
Arrange the following phases of database design in the correct order :(A) Physical Design(B) Conceptual Design(C) Logic…
Topic: UGC NET Computer Science August 2024 (Paper II)
3
Which of the following are Agile Process Models ? (A) Extreme Programming (XP) (B) Waterfall (C) Scrum (D) Spiral (E) I…
Topic: UGC NET Computer Science August 2024 (Paper II)
4
Consider the following statement regarding special purpose registers. (A) Program Counter (PC) keeps the track of next …
Topic: UGC NET Computer Science August 2024 (Paper II)
5
Consider the transactions $T_1, T_2, T_3$ and the schedules $S_1$ and $S_2$ given below. $T_1 : r_1(x); r_1(z); w_1(z)$…
Topic: UGC NET Computer Science August 2024 (Paper II)
6
Match List - I with List - II. List - I (software design principles) List - II (Definitions) (A) Cohesio…
Topic: UGC NET Computer Science August 2024 (Paper II)
7
Given a project that uses the COCOMO model with an estimated effort of 2000 person-months and a productivity rate of 5 …
Topic: UGC NET Computer Science August 2024 (Paper II)
8
What is SQL primarily used for in the context of relational databases?
Topic: UGC NET Computer Science August 2024 (Paper II)
9
What will be the output of the following C code?#include<stdio.h>void main(){    int arr[5] = {10, 20, …
Topic: UGC NET Computer Science August 2024 (Paper II)
10
Match List - I with List - II. List - I (IP Address)List - II (Class)   (A) 10.20.30.40 (I) Class E…
Topic: UGC NET Computer Science August 2024 (Paper II)

Next 10 Questions — UGC NET Computer Science August 2024 (Paper II)

Ascending by ID
1
Host A (on TCP/IPv4 Networks) send an IP Datagram D to host B (also on TCP/IPv4 network). Assume that no error occurred…
Topic: UGC NET Computer Science August 2024 (Paper II)
2
Consider a CSMA/CD network that transmits data at the rate of 100 Mbps over a 1 kilometre cable with no repeater. If th…
Topic: UGC NET Computer Science August 2024 (Paper II)
3
#include<iostream.h>using namespace std;void swap(int &x, int &y){    int temp = x;  &nbsp…
Topic: UGC NET Computer Science August 2024 (Paper II)
4
Consider the three-way handshaking process followed during TCP connection establishment between two hosts A and B. Let …
Topic: UGC NET Computer Science August 2024 (Paper II)
5
Arrange the following steps of file handling in C in the correct order :(A) Close the file(B) Read from or write to the…
Topic: UGC NET Computer Science August 2024 (Paper II)
6
Select the Sorting Algorithms that are stable.(A) Quick Sort(B) Bubble Sort(C) Insertion Sort(D) Merge Sort(E) Shell So…
Topic: UGC NET Computer Science August 2024 (Paper II)
7
Match List - I with List - II. List - I (operating system concepts)List - II (characteristics)  (A) Pagi…
Topic: UGC NET Computer Science August 2024 (Paper II)
8
Which of the following statements are TRUE about Process Control Block (PCB) ?(A) The PCB contains information about th…
Topic: UGC NET Computer Science August 2024 (Paper II)
9
Arrange the following steps of Feature Driven Development (FDD) process in the correct sequence :(A) Develop an overall…
Topic: UGC NET Computer Science August 2024 (Paper II)
10
Match List - I with List - II. List - I (Recurrence Relations)List - II (Complexity)  (A) $T(n)=2T(n/2)+…
Topic: UGC NET Computer Science August 2024 (Paper II)
Ask Your Question or Put Your Review.

loading...