Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 630
|
Match the following :
|
i-a, ii-c, iii-b, iv-d
|
|
|
i-d, ii-c, iii-a, iv-b
|
|
|
i-d, ii-c, iii-b, iv-a
|
|
|
i-a, ii-b, iii-c, iv-d
|
|
|
None of the above
|
Question 630 Explanation:
→ 2NF ensures no partial dependency in the relation.
→ A relation is in 3NF if it is in eliminates transitive dependency from the relation.
→ 4NF eliminates multivalued dependency from a relation.
→ 5NF eliminates join dependency from a table.
→ A relation is in 3NF if it is in eliminates transitive dependency from the relation.
→ 4NF eliminates multivalued dependency from a relation.
→ 5NF eliminates join dependency from a table.
Correct Answer: E
Question 630 Explanation:
→ 2NF ensures no partial dependency in the relation.
→ A relation is in 3NF if it is in eliminates transitive dependency from the relation.
→ 4NF eliminates multivalued dependency from a relation.
→ 5NF eliminates join dependency from a table.
→ A relation is in 3NF if it is in eliminates transitive dependency from the relation.
→ 4NF eliminates multivalued dependency from a relation.
→ 5NF eliminates join dependency from a table.