Question 17256 – NTA UGC NET JUNE 2023 Paper-1
January 30, 2024Question 6671 – Closure-Property
January 30, 2024Question 10559 – Database-Management-System
Choose the correct alternatives (More than one may be correct).
Indicate which of the following statements are true:
A relational database which is in 3NF may still have undesirable data redundancy because there may exist:
Correct Answer: E
Question 17 Explanation:
A) Transitive functional dependency, so not in 3NF.
B) 3NF because right side is prime attribute.
C) Not in 3NF, because lets suppose ABC is a candidate key. Now consider
AB → Non-prime attribute
which show it is not in 3NF
D) Involves only prime attribute, so right side should definitely contain only prime attribute. So in 3NF.
B) 3NF because right side is prime attribute.
C) Not in 3NF, because lets suppose ABC is a candidate key. Now consider
AB → Non-prime attribute
which show it is not in 3NF
D) Involves only prime attribute, so right side should definitely contain only prime attribute. So in 3NF.
Transitive functional dependencies.
Non-trivial functional dependencies involving prime attributes on the right-side.
Non-trivial functional dependencies involving prime attributes only on the left-side.
Non-trivial functional dependencies involving only prime attributes.
Both (B) and (D).
Subscribe
Login
0 Comments