1
GATE CSE 2013
MCQ (Single Correct Answer)
+2
-0.6
Relation $$R$$ has eight attribution $$ABCDEFGH.$$ Fields of $$R$$ contain only atomic values.
$$F = \left\{ {CH \to G,\,\,A \to BC,\,B \to CFH,\,\,E \to A,\,\,F \to EG} \right\}$$ set of functional dependencies $$(FDs)$$ so that $${F^ + }$$ is exactly the set of $$FDs$$ that hold for $$R.$$

How many candidate keys does the relation $$R$$ have?

A
$$3$$
B
$$4$$
C
$$5$$
D
$$6$$
2
GATE CSE 2013
MCQ (Single Correct Answer)
+2
-0.6
Relation $$R$$ has eight attribution $$ABCDEFGH.$$ Fields of $$R$$ contain only atomic values.
$$F = \left\{ {CH \to G,\,\,A \to BC,\,B \to CFH,\,\,E \to A,\,\,F \to EG} \right\}$$ set of functional dependencies $$(FDs)$$ so that $${F^ + }$$ is exactly the set of $$FDs$$ that hold for $$R.$$

The relation $$R$$ is

A
in $$1NF,$$ but not in $$2NF.$$
B
in $$2NF,$$ but not in $$3NF.$$
C
in $$3NF,$$ but not in $$BCNF$$
D
in $$BCNF.$$
3
GATE CSE 2008
MCQ (Single Correct Answer)
+2
-0.6
Let $$R\left( {A,\,B,\,C,\,D,E,P,G} \right)$$ be a relational schema in which the following functional dependencies are known to hold: $$AB \to CD,\,\,DE \to P,\,\,C \to E.\,\,P \to C$$ and $$B \to G.$$ The relational schema $$R$$ is
A
In $$BCNF$$
B
In $$3NF,$$ but not in $$3NF$$
C
In $$2NF,$$ but not in $$3NF$$
D
Not in $$2NF$$
4
GATE CSE 2008
MCQ (Single Correct Answer)
+2
-0.6
Consider the following relational schemes for a library database. Book ( Title, Author, Catalog_ no, Publisher, Year, Pr ice ) Collection ( Title, Author, Catalog no )
With in the following functional dependencies:
$${\rm I}.\,\,\,\,\,\,$$ Title Author $$ \to $$ Catalog_no
$${\rm II}.\,\,\,\,$$ Catalog_no $$ \to $$ Title Author Publisher Year
$${\rm III}.\,\,\,\,$$ Publisher Title Year $$ \to $$ Price

Assume { Author, Title } is the key for both schemes. Which of the following statements is true?

A
Both Book and Collection are in $$BCNF$$
B
Both Book and Collection are in $$3$$ $$NF$$ only
C
Book is in $$2$$ $$NF$$ and Collection is in $$3$$ $$NF$$
D
Both Book and Collection are in $$2$$ $$NF$$ only
GATE CSE Subjects
Software Engineering
Web Technologies
EXAM MAP