-
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 is TRUE and S2 is FALSE.
- Both S1 and S2 are TRUE.
- S1 is FALSE and S2 is TRUE.
- Both S1 and S2 are FALSE.
- S1 is TRUE and S2 is FALSE.
Correct Option: A
S1 is true and S2 is false.
S1: Every table with two single valued attributes is in 1 NF, 2NF, 3NF and BCNF
S1 is trially true by the definition of all normal forms.
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.
It is clearly false as any combination of the functional dependencies AB → C, D → E, E → C cannot generate the function. dependency AB→ E. Since AB→ E cannot be inferred, the given set cannot be the minimal cover. So, S2 is false.
Finally, S1 is true and S2 is false.
