1
GATE CSE 2008
MCQ (Single Correct Answer)
+2
-0.6
Consider the following $$ER$$ diagram GATE CSE 2008 Database Management System - Er Diagrams Question 8 English

Which of the following is a correct attribute set for one of the tables for the correct answer to the above question?

A
$$\left\{ {M1,\,M2,\,M3,\,P1} \right\}$$
B
$$\left\{ {M1,\,P1,\,N1,\,N2} \right\}$$
C
$$\left\{ {M1,\,P1,\,N1} \right\}$$
D
$$\left\{ {M1,\,P1} \right\}$$
2
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
3
GATE CSE 2008
MCQ (Single Correct Answer)
+2
-0.6
Let $$R\left( {A,B,C,D} \right)$$ be a relational schema with the following functional dependencies:
$$A \to B,\,\,B \to C,\,\,C \to D$$ and $$D \to B.$$
The decomposition of $$R$$ into $$(A,B), (B,C)$$ and $$(B,D)$$
A
gives a lossless join, and is dependency preserving
B
gives a lossless join, but is not dependency preserving.
C
does not give a lossless join, but is dependency preserving
D
does not give a lossless join and is not dependency preserving
4
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$$
EXAM MAP
Medical
NEET
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
CBSE
Class 12