Combinational-Circuit
December 31, 2023K-Map
December 31, 2023Question 8894 – ISRO CS 2020
If every non-key attribute functionally dependent on the primary key, then the relation will be in
Correct Answer: B
Question 23 Explanation:
1. Let’s take a relation R(ABC) with functional dependencies {A → B, B → C, A → C}.
2. In the question it is not mentioned that non-prime attribute is only dependent on primary key.
3. So, the functional dependency B → C, is perfectly valid.
4. This relation is in 2NF but not in 3NF because of every non-key attribute is transitively dependent on the primary key. Here “A” will be a candidate key.
2. In the question it is not mentioned that non-prime attribute is only dependent on primary key.
3. So, the functional dependency B → C, is perfectly valid.
4. This relation is in 2NF but not in 3NF because of every non-key attribute is transitively dependent on the primary key. Here “A” will be a candidate key.
First normal form
Second normal form
Third normal form
Fourth normal form