GATE CSE 2014 Set 3 | Functional Dependencies and Normalization Question 14 | Database Management System

PREVIOUS NEXT

GATE CSE 2014 Set 3

MCQ (Single Correct Answer)

-0.3

A prime attribute of a relation scheme $$R$$ is an attribute that appears

In all candidate keys of $$R$$

In some candidate key of $$R.$$

In a foreign key of $$R.$$

Only in the primary key of $$R.$$

GATE CSE 2014 Set 2

Numerical

-0

The maximum number of superkeys for the relation schema $$R(E, F, G, H)$$ with $$E$$ as key is ______.

Your input ____

GATE CSE 2014 Set 1

MCQ (Single Correct Answer)

-0.3

Consider the relation schema $$R = \left( {E,\,F,\,G,\,H,\,I,\,J,\,K,L,\,M,\,N} \right)$$ and the set of functional dependencies $$\left\{ {\left\{ {E,F} \right\} \to \left\{ G \right\},\left\{ F \right\}} \right.$$
$$ \to \left\{ {I,J} \right\},\left\{ {E,H} \right\} \to \left\{ {K,L} \right\},\left\{ K \right\}$$
$$ \to \left\{ M \right\},\left\{ L \right\}$$
$$ \to \left. {\left\{ N \right\}} \right\}$$ on $$R.$$ What is the key for $$R?$$

$$\left\{ {E,F} \right\}$$

$$\left\{ {E,F,H} \right\}$$

$$\left\{ {E,\,F,\,H,\,K,\,L} \right\}$$

$$\left\{ E \right\}$$

GATE CSE 2012

MCQ (Single Correct Answer)

-0.3

Which of the following is TRUE?

Every relation in $$3NF$$ is also in $$BCNF$$

A relation $$R$$ is in $$3NF$$ if every non-prime attribute of $$R$$ is fully functionally dependent on every key of $$R$$

Every relation in $$BCNF$$ is also in $$3NF$$

No relation can be in both $$BCNF$$ and $$3NF$$