Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 518 |
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 518 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 518 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.
Subscribe
Login
0 Comments