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
Subscribe
Login
0 Comments