Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Normalization
|
Question 89
|
Match the following :
|
I-(a), II-(c), III-(b), IV-(d)
|
|
|
I-(d), II-(a), III-(b), IV-(c)
|
|
|
I-(c), II-(d), III-(a), IV-(b)
|
|
|
I-(d), II-(b), III-(a), IV-(C)
|
|
|
I-(c), II-(a), III-(b), IV-(d)
|
Question 89 Explanation:
→ 2NF ensures that the relation contains no partial dependency. A relation is in 2NF if it is in 1NF and have no partial dependency.
→ 3NF eliminates transitive dependency from the relation. A relation can be in 3NF if it is in 2NF and have no transitive dependency.
→ 4NF eliminates multivalued dependency from the relation. A relation is in 4NF if it is in BCNF and have no multivalued dependency.
→ 5NF ensures that the relation contains no join dependency. A relation is in 5NF if it is 4NF and ave no join dependency.
Note: Given question is wrong. We are added correct extra option. Excluded for correction.
→ 3NF eliminates transitive dependency from the relation. A relation can be in 3NF if it is in 2NF and have no transitive dependency.
→ 4NF eliminates multivalued dependency from the relation. A relation is in 4NF if it is in BCNF and have no multivalued dependency.
→ 5NF ensures that the relation contains no join dependency. A relation is in 5NF if it is 4NF and ave no join dependency.
Note: Given question is wrong. We are added correct extra option. Excluded for correction.
Correct Answer: E
Question 89 Explanation:
→ 2NF ensures that the relation contains no partial dependency. A relation is in 2NF if it is in 1NF and have no partial dependency.
→ 3NF eliminates transitive dependency from the relation. A relation can be in 3NF if it is in 2NF and have no transitive dependency.
→ 4NF eliminates multivalued dependency from the relation. A relation is in 4NF if it is in BCNF and have no multivalued dependency.
→ 5NF ensures that the relation contains no join dependency. A relation is in 5NF if it is 4NF and ave no join dependency.
Note: Given question is wrong. We are added correct extra option. Excluded for correction.
→ 3NF eliminates transitive dependency from the relation. A relation can be in 3NF if it is in 2NF and have no transitive dependency.
→ 4NF eliminates multivalued dependency from the relation. A relation is in 4NF if it is in BCNF and have no multivalued dependency.
→ 5NF ensures that the relation contains no join dependency. A relation is in 5NF if it is 4NF and ave no join dependency.
Note: Given question is wrong. We are added correct extra option. Excluded for correction.