1
GATE CSE 2005
MCQ (Single Correct Answer)
+1
-0.3
A table has fields, $$F1, F2, F3, F4, F5,$$ with the following functional dependencies:
$$F1 \to F3.\,F2 \to F4.\,\,\,\left( {F1\,.\,F2} \right) \to F5$$ in terms of Normalization, this table is in
A
$$1NF$$
B
$$2NF$$
C
$$3NF$$
D
None of these
2
GATE CSE 2005
MCQ (Single Correct Answer)
+2
-0.6
In a schema with attributes $$A, B, C, D,$$ and $$E,$$ following set of functional dependencies are given
$$\eqalign{ & \,\,\,A \to B \cr & \,\,\,A \to C \cr & CD \to E \cr & \,\,\,B \to D \cr & \,\,\,E \to A \cr} $$

Which of the following functional dependencies is NOT implied by the above set?

A
$$CD \to AC$$
B
$$BD \to CD$$
C
$$BC \to CD$$
D
$$AC \to BC$$
3
GATE CSE 2005
MCQ (Single Correct Answer)
+1
-0.3
Consider the entities 'hotel room', and 'person' with a many to many relationship 'lodging' as shown below GATE CSE 2005 Database Management System - Er Diagrams Question 7 English

If we wish to store information about the rent payment to be made by person(s) occupying different hotel rooms, then this information should appear as an attribute of

A
Person
B
Hotel Room
C
Lodging
D
None of these
4
GATE CSE 2005
MCQ (Single Correct Answer)
+2
-0.6
Consider a relation scheme $$R = \left( {A,\,B,\,C,\,D,\,E,\,H} \right)$$ on which the following functional dependencies hold: $$\left\{ {A \to B,\,\,BC \to D,\,\,E \to C,\,\,D \to A} \right\}.$$ What are the candidate keys of $$R?$$
A
$$AE, BE$$
B
$$AE, BE, DE$$
C
$$AEH, BEH, BCH$$
D
$$AEH, BEH, DEH$$