GATE Exam | Aptitude Questions | GATE Syllabus | GATE Result | Mock Test | GATE Preparation
0 votes

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?

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.

asked in normal forms by gate

1 Answer

–1 vote

S1 is TRUE and S2 is FALSE.

answered by gate
How  can you assume that the two "single valued" attributes in S1 are unique? What if the table is of attribute (FirstName, Gender)? Since no key is present in such a table it won't be in 1NF?

Related questions

The best answer to any question