1
GATE CSE 2014 Set 1
MCQ (Single Correct Answer)
+2
-0.6
Given the following two statements:
$$S1:$$ Every table with two single-valued attributes is in $$1NF, 2NF, 3NF$$ and $$BCNF.$$
$$S2:$$ $$AB \to C,\,\,D \to E,\,\,E \to C$$ is a minimal cover for the set of functional dependencies $$AB \to C,$$ $$D \to E,\,\,AB \to E,\,\,E \to C.$$

Which one of the following is CORRECT?

A
$$S1$$ is TRUE and $$S2$$ is FALSE
B
Both $$S1$$ and $$S2$$ are TRUE.
C
$$S1$$ is FALSE and $$S2$$ is TRUE.
D
Both $$S1$$ and $$S2$$ are FALSE.
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.$$

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

A
$$3$$
B
$$4$$
C
$$5$$
D
$$6$$
3
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.$$
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
Medical
NEET
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
CBSE
Class 12