Normalization
September 2, 2024Normalization
September 2, 2024Normalization
| Question 58 |
Consider the following table
The table is in which normal form?
The table is in which normal form?
| First Normal Form | |
| Second Normal Form | |
| Third Normal Form but not BCNF | |
| Third Normal Form but BCNF |
Question 58 Explanation:
From the given figure, we can write functional dependencies as
AB→ CDE
C→ B
The candidate keys are “AB” and “AC”.
The relation is not in BCNF because the functional dependencies C→ B do not contains the key AB or AC
So, the given relation is in 3NF but not in BCNF
AB→ CDE
C→ B
The candidate keys are “AB” and “AC”.
The relation is not in BCNF because the functional dependencies C→ B do not contains the key AB or AC
So, the given relation is in 3NF but not in BCNF
Correct Answer: C
Question 58 Explanation:
From the given figure, we can write functional dependencies as
AB→ CDE
C→ B
The candidate keys are “AB” and “AC”.
The relation is not in BCNF because the functional dependencies C→ B do not contains the key AB or AC
So, the given relation is in 3NF but not in BCNF
AB→ CDE
C→ B
The candidate keys are “AB” and “AC”.
The relation is not in BCNF because the functional dependencies C→ B do not contains the key AB or AC
So, the given relation is in 3NF but not in BCNF