Computer Sciences > GATE 2014 SET-1 > Normalization
Given the following two statements:
S1: Every table with two single-valued attributes is in 1NF, 2NF, 3NF and BCNF.
S2: AB → C, D → E, E → C is a minimal cover for the set of functional dependencies AB → C, D → E, AB → E, E → C.
Which one of the following is CORRECT?
S1: Every table with two single-valued attributes is in 1NF, 2NF, 3NF and BCNF.
S2: AB → C, D → E, E → C is a minimal cover for the set of functional dependencies AB → C, D → E, AB → E, E → C.
Which one of the following is CORRECT?
Correct : a
Similar Questions
A database of research articles in a journal uses the following schema.
(VOLUME, NUMBER, STARTPGE, ENDPAGE, TITLE, YEAR, PRICE)
The primary key is (VOLUME, NUM...
Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE ?
Consider the relation R(P, Q, S, T, X, Y, Z, W) with the following functional dependencies.PQ -> X, P -> YX, Q -> Y, Y -> ZWConsider the decomposition of the re...
Total Unique Visitors
Loading......