Aspire Faculty ID #19108 · Topic: UGC NET Computer Science Dec 2019 (Paper II) · Just now
UGC NET Computer Science Dec 2019 (Paper II)

An organization needs to maintain database having five attributes $A,B,C,D,E$. These attributes are functionally dependent on each other for which functional dependency set $F$ is given as:

$F={A\rightarrow BC,\ D\rightarrow E,\ BC\rightarrow D,\ A\rightarrow D}$

Consider a universal relation $R(A,B,C,D,E)$ with functional dependency set $F$. Also all attributes are simple and take atomic values only.

Identify the normal form in which relation $R$ belong to.

Solution

$A$

Since the primary key contains only one attribute, there is no partial dependency.

So, relation $R$ is in $2NF$.

Now check for $3NF$.

Given dependency:

$D\rightarrow E$

Here, $D$ is not a super key and $E$ is a non-prime attribute.

So, relation is not in $3NF$.

Therefore, the highest normal form of relation $R$ is:

$2NF$

← Previous Next →

Previous 10 Questions — UGC NET Computer Science Dec 2019 (Paper II)

Nearest first
1
An organization needs to maintain database having five attributes $A,B,C,D,E$. These attributes are functionally depend…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
 2
 Minimal cover $F'$ of functional dependency set $F$ is: Given: $F={A\rightarrow BC,\ D\rightarrow E,\ BC\rightarr…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
 3
How many predicate nodes are there and what are their names?
Topic: UGC NET Computer Science Dec 2019 (Paper II)
 4
How many nodes are there in the longest independent path?
Topic: UGC NET Computer Science Dec 2019 (Paper II)
 5
How many regions are there in flowgraph $F$?
Topic: UGC NET Computer Science Dec 2019 (Paper II)
 6
 What is the cyclomatic complexity of flowgraph $F$?
Topic: UGC NET Computer Science Dec 2019 (Paper II)
 7
 How many nodes are there in flowgraph $F$?
Topic: UGC NET Computer Science Dec 2019 (Paper II)
 8
The Data Encryption Standard $($DES$)$ has a function consists of four steps. Which of the following is correct order o…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
 9
The sequence diagram given in Figure $1$ for the Weather Information System takes place when an external system request…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
 10
Match List-I with List-II: List-I Term List-II Description (a) …
Topic: UGC NET Computer Science Dec 2019 (Paper II)

Next 10 Questions — UGC NET Computer Science Dec 2019 (Paper II)

Ascending by ID
1
An organization needs to maintain database having five attributes $A,B,C,D,E$. These attributes are functionally depend…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
 2
An organization needs to maintain database having five attributes $A,B,C,D,E$. These attributes are functionally depend…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
Ask Your Question or Put Your Review.

loading...