3. Given relation R(A, B, C, D, E) having candidate kev A and cadidate key D\'an

Question

3. Given relation R(A, B, C, D, E) having candidate kev A and cadidate key D'and no other candidate keys), assuming the relation is in INF, what's the most we know? a) given this limited information, we are told the relation is in 1NF, but we cannot know more than this without infonmation about the FDs b) given this limited information, the relation must also be in 2NF e) given this limited information, the relation must also be in 3NF d) given this limited information, the relation must also be in BCNE

Explanation / Answer

From the question :

Given relation R(A,B,C,D) having candidate key A and candidate key D

Here the relation is in 1NF but we cant know more than this without information about the FDs.

A normal form is is state of relation that results by decomposing that relation to avoid redundancy.

Since we dont know the FDs so we cant decomposing that relation, So we dont about other normal forms like 2NF, 3NF and BCNF

Option a correct

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.