Recent questions tagged database-normalization

0 votes
1 answer
35
given an instance of relation R(ABC). find all non-trivial FDsare AB->C, AC->B, BC→ A true ??
1 votes
0 answers
37
1 votes
0 answers
39
2 votes
3 answers
40
A Relation R is in 3NF and have only 1 Candidate Key(may or may not be composite), then R is in BCNF. True or False??
2 votes
1 answer
41
I think the answer should be (B) would be right, because lets say in R, there is a FD NPA - CK, it won't qualify as BCNF even if CK is single attribute
1 votes
0 answers
42
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attributeTrue or false
0 votes
1 answer
44
Match List I with List II :$\begin{array}{ll} \text{List I} & \text{List II} \\ \\\text {(A) BCNF } & \text { (I) It removes multivalued dependency } \\\text {(B) 3} \mat...